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 “refrigerators” 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.

75 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
refrigerators176175(None) 
refrigerator1661951refrigerator_
refrigerates1653502refrigerat_es
refrigerations1863772refrigerations
refrigerants1651633refrigera_nts
refrigerate1553623refrigerat__e
refrigerated1753203refrigerat_ed
refrigerating1853183refrigerating
refrigeration1764153refrigeration
denigrators1344524de_nig_rators
exaggerators2162244_exaggerators
refrigerant1552394refrigera__nt
regenerators1353834re_generators
reinvigorators1891654reinvigorators
remunerators1453664re_munerators
respirators1375444respi__rators
deaerators11107715de___aerators
decelerators1553495de_celerators
defecators1656255def___ecators
delineators1253965de_line_ators
denigrator1245225de_nig_rator_
denigratory1653515de_nig_ratory
depredators1543745depr__edators
designators1344305de_sig_nators
enumerators1353955_e_numerators
erigerons1044905_e_riger__ons
exaggerator2052435_exaggerator_
exaggeratory2461875_exaggeratory
federators1446195__f_ederators
figeaters1345755__f_ige_aters
generators1147535ge___nerators
incinerators1463435_incinerators
infiltrators1552745inf_iltrators
invigorators1653145_invigorators
irrigators1145635_irrig__ators
liberators1247025___liberators
literators1048105___literators
meliorators13115005me_li_orators
migrators1247545___mig_rators
obliterators1452605_obliterators
originators1253925__originators
perforators1644855pe_r_forators
permeators1447405pe_r_me_ators
perorators1249355pe_r__orators
perpetrators1653395pe_rpetrators
prefigurations2053025pref_igurations
recriminatory2062645recriminatory
redecorators1552665re_decorators
reflectors1545505ref__le_ctors
refractors15156275refr___actors
regenerator1254565re_generator_
regulators1146505re___gulators
reinvigorator1771875reinvigorator_
reiterates10412015re__iterat_es
reiterations12410875re__iterations
rejuvenators2251495re_juvenators
remigrates1348585re_mig_rat_es
remigrations15227795re_mig_rations
remonstrators1583565remonstrators
remunerator1353875re_munerator_
remuneratory1752905re_muneratory
respirator1265735respi__rator_
respiratory16104135respi__ratory
retreaters1047555retr__e_aters
revelators13116435re___velators
reverberatory2161415reverberatory
rubricators1553745rubri__cators
tergiversators1871095tergiversators
triceratops1551765__triceratops
triturators1153745__triturators
unrefrigerated196925unrefrigerat_ed
variegators1552715_vari_egators
venerators1347065ve___nerators
verbigerations2052475verbigerations
vociferators2082215_vociferators

Search took 10 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.393454684.5
2DLD Change Limit124790758.61014493.6
3Display Results75750.0461630.4
 (SQL Overall)178691759.04919747.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.