Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “supererogations” with Change Limit: [1] [2] [3] [4] [5] [6]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

51 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
supererogations186283(None) 
supererogation1763061supererogation_
superelevations2062763superelevations
supererogatory2071133supererogat_ory
interrogations1556814inter_rogations
prorogations1556714__p_rorogations
subirrigations17102404subir_rigations
subrogations1545454su___brogations
superannuations1763804superannuations
superelevation1963004superelevation_
superfetations1975064super_fetations
supernations14410874sup__er_nations
superovulations2063364superovulations
superpositions18145264super_positions
superstations15208144sup__erstations
arrogations12126485___ar_rogations
derogations1349395____derogations
impersonations1863655imper_sonations
interrogation1457865inter_rogation_
percolations1648045__per_colations
peregrinations17114685__peregrinations
perennations1447255__pere_nnations
perforations1747875__per_forations
perorations13314065__p__erorations
personations1448395__per_sonations
prerogatives1853435__p_rerogatives
prorogation1447395__p_rorogation_
segregations1445805s__e_gregations
serrations10313095s__er_r__ations
suberizations2468775su__berizations
subgenerations1752515subgener__ations
subirrigation1652645subir_rigation_
subrogation1446005su___brogation_
superadditions1863405super_additions
superannuation16104225superannuation_
superelevating2082305superelevati_ng
superfetation1855225super_fetation_
superinductions2063705superinductions
superinfections2263415superinfections
supernation13411665sup__er_nation_
supernutritions1763435supernutritions
superorganisms1962285superor_ganisms
superovulation1963545superovulation_
superposition17135595super_position_
superscriptions2163345superscriptions
superstation14168625sup__erstation_
superstitions15176785sup__erstitions
superventions18125785sup__erventions
suppurations1645205sup_pur__ations
surrogating13194325su__r_rogati_ng
susurrations1244335susur_r__ations

Search took 5 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691658740.1101624463.6
2DLD Change Limit65874514.17015797.1
3Display Results51510.0331545.5
 (SQL Overall)178691514.31341430.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.