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 “deflagration” with Change Limit: [1] [2] [3] [4] [5]

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

77 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
deflagration177347(None) 
deflagrations1883021deflagrations
declaration1447832decla_ration
deflagrating1852662deflagrating
defloration1547262defl_oration
conflagration1953013conflagration
deaeration11313013de__aeration
declamation1646103decla_mation
declarations1546803decla_rations
defalcation1746223def_alcation
defamation1646843def_a_mation
deflagrate15143393deflagrat__e
deflagrated17132993deflagrat_ed
deflagrates16133243deflagrat_es
deflation13310653defl___ation
deflorations1646063defl_orations
deglaciation1654303deglaciation
delegation1238883de_leg_ation
denigration1348463de_nigration
celebration1546464ce_lebration
conflagrations2052724conflagrations
deaerations12311674de__aerations
dealation10313004de__a_lation
debarkation1844244de_barkation
decantation1448944de_cantation
deceleration1547174deceleration
declamations1745304decla_mations
declarative1754314decla_rative
declination14411874decl_ination
decoration13314424de__coration
defalcations1845194def_alcations
defamations1745894def_a_mations
defecation1679804def__ecation
deflations1439714defl___ations
deflection16147734defl__ection
defoliation1548314def_oliation
deformation1747664def_ormation
degeneration1447284degeneration
deglaciations1753914deglaciations
degradation1445384degra_dation
dehydration1954064de_hydration
delamination1548854de_lamination
delation92318084de_l___ation
delectation1448554de_lectation
delegations1348034de_leg_ations
deliberation1546364deliberation
delineation1247764de_lineation
demarcation1647024de_marcation
denaturation1345884denaturation
denegation1249414de_neg_ation
denigrations1447354de_nigrations
depravation1785694depra_vation
dermabrasion176894dermabrasion
derogation12410394de_rog_ation
desalination13411134desalination
desecration14410074de_secration
desideration1456394desideration
designation1347484de_signation
desperation14510114de_speration
deuteration1249104de_uteration
devaluation1547074de_valuation
devastation1546734de_vastation
dilatation1147394d_ila_tation
divagation15104374d_ivag_ation
elaboration1345744_e_laboration
emigration13228214_e_migration
inflammation19132884inflammation
melioration1368184me_lioration
reclamation1546354recla_mation
reflation12412334refl___ation
refrigeration1764154refrigeration
relaxation1746454re_la_xation
relegation11610024re_leg_ation
remigration14228914re_migration
reparation12612724re_pa_ration
replantation1445524replantation
separation12510434se_pa_ration

Search took 9 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 Filter1786911247900.390458182.1
2DLD Change Limit124790777.97015657.5
3Display Results77770.0431790.7
 (SQL Overall)178691778.40321265.1
 
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.