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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

197 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
refrigerations186377(None) 
refrigeration1764151refrigeration_
refrigerating1853182refrigerati_ng
refrigerators1761752refrigerat_ors
prefigurations2053023pref_igurations
refrigerates1653503refrigerat__es
refrigerator1661953refrigerat_o_r
reiterations12410873re__iterations
remigrations15227793re_mig_rations
verbigerations2052473verbigerations
deflagrations1883024deflag_rations
deliberations1645534de_liberations
denigrations1447354de_nig_rations
desiderations1545674de_siderations
emigrations14187154_e_mig_rations
exaggerations2253484_exaggerations
figurations1545084__f_igurations
prefiguration1953454pref_iguration_
recreations13412254recr__e_ations
recriminations1856724recriminations
recuperations1746084re_cuperations
redigestions1483864re_dige_stions
refrigerant1552394refrigera___nt
refrigerants1651634refrigera__nts
refrigerate1553624refrigerat___e
refrigerated1753204refrigerat__ed
regenerations1447144re_generations
registrations1446894re_gistrations
reintegrations15164784reintegrations
reinvigorations19152414reinvigorations
reiteration11412164re__iteration_
remigration14228914re_mig_ration_
remunerations1556204re_munerations
reoperations14410064re__operations
reorientations1465214reorientations
reregulations1455714re_regulations
resignations1346884re_sig_nations
respirations14410304respi__rations
revegetations17114714re_vegetations
reverberations19113584reverberations
verbigeration1952864verbigeration_
alliterations1384555_alliterations
cerebrations1646965ce_r_ebrations
commiserations2053455commiserations
configurations2063705configurations
considerations1764845considerations
deaerations12311675de___aerations
decelerations1646425de_celerations
defecations1779005def___ecations
deflagration1773475deflag_ration_
deflorations1646065def__lorations
degenerations1546355de_generations
deliberation1546365de_liberation_
delineations1346765de_line_ations
denigration1348465de_nig_ration_
deoxygenations2661745deoxygenations
deprecations1748565depr__ecations
depredations1646735depr__edations
deprivations1897925depri__vations
deregulations1545205de_regulations
derivations15611495de_ri__vations
derogations1349395de_rog__ations
desideration1456395de_sideration_
designations1456945de_sig_nations
desperations1559525de__sperations
deteriorations15164695deteri_orations
deuterations1348085de__uterations
emigration13228215_e_mig_ration_
enumerations14135515_e_numerations
erigerons1044905_e_riger___ons
eviscerations1882705_eviscerations
exaggeration2153865_exaggeration_
exasperations2253695_exasperations
exenterations2054485_exenterations
exhilarations2352415_exhilarations
exonerations1947015_e_xonerations
expirations2069585_expi__rations
federations1548885__f_ederations
figuration1445915__f_iguration_
filtrations1445625__f_iltrations
frustrations1544535__frustrations
fulgurations1692795__fulgurations
generations12311425ge___nerations
hydrogenations22103245hydrogenations
immigrations1743725_immig_rations
incinerations1545685_incinerations
infiltrations1653905inf_iltrations
invigorations1753915_invigorations
irrigations1246945_irrig__ations
iterations10413825____iterations
itinerations1245685__itinerations
levigations1546215le_vig__ations
liberations1358945___liberations
literations11610585___literations
meliorations1466755me_li_orations
mercurations1646565me_r_curations
metrications1649835metri__cations
migrations13168685___mig_rations
obliterations1553455_obliterations
originations13106185__originations
perforations1747875pe_r_forations
permeations1549885pe_r_me_ations
perorations13314065pe_r__orations
perpetrations1746375pe_rpetrations
perseverations1953245perseverations
perspirations1786175pe_rspirations
petrifications2148025petrifications
predigestions1773285pre_dige_stions
premigration1755695pre_mig_ration_
preponderations20112875preponderations
proliferations1952705proliferations
reaffirmations2251975reaffi_rmations
reaggregations1762845reaggregations
realizations21415535reali__zations
reanimations1468785reani__mations
reannexations2052835re_annexations
reassertions1253645re_asser_tions
recalibrations1853695recalibrations
recirculations1884225recirculations
recitations13314205re_ci__tations
reconsecrations1995105reconsecrations
recreation12413615recr__e_ation_
recrimination1757405recrimination_
rectifications2148915rectifications
recuperation1656725re_cuperation_
redecorations1645085re_decorations
redigestion1384155re_dige_stion_
redintegrations17143255redintegrations
redirections1546175re_dire_ctions
refections151811645ref___e_ctions
reflations13311235ref____lations
reflections16178555ref__le_ctions
reforestations1754465reforestations
reformations1747605ref__ormations
reformulations1953555reformulations
refoundations17102635ref_oundations
refractions16127725refr___actions
refutations1448675ref___utations
regeneration1348195re_generation_
regimentations1784855re_gimentations
registration1347535re_gistration_
regulations12310715re___gulations
regurgitations16133145regurgitations
rehydrations1943985re__hydrations
reifications17411825re__ifications
reignitions1244555re__ig_nitions
reinflations1546645re__inflations
reinnervations1753445re_innervations
reinsertions1245275re_inser_tions
reintegration14175375reintegration_
reinvigoration18152715reinvigoration_
reiterating12410495re__iterati_ng
rejuvenations23122695re_juvenations
relegations1248975re___legations
remigrating1547595re_mig_rati_ng
remonstrations16116485remonstrations
remuneration1446935re_muneration_
renaturations1355965re_naturations
reoperation13410905re__operation_
reorientation1375595reorientation_
reoxidations2046045reoxi__dations
reparations13611665re___parations
replications16811055repli__cations
representations17153895representations
repristinations17193925repristinations
reprobations1647775repr__obations
reradiations1349495re_r_adiations
reregistrations1672825reregistrations
reregulation1346415re_regulation_
resegregations1653695resegregations
reservations1588585re___servations
resignation1247475re_sig_nation_
respiration13511195respi__ration_
restimulations1654645restimulations
restorations12410955re__storations
reticulations1556615re_ticulations
retranslations1454215retranslations
retributions14134945retri__butions
retrogradations17151645retrogradations
retrogressions15113165retrogressions
retroversions1673455retrover_sions
reunifications19136915reunifications
reutilizations2348715reutilizations
revegetation16105305re_vegetation_
revelations14410305re___velations
reverberation1893885reverberation_
rubrications1646265rubri__cations
segregations1445805segr__egations
seriations10316685se_ri___ations
serrations10313105se_r___rations
tergiversations1971385tergiversations
triturations1245685__triturations
variegations1643455_vari_egations
vegetations1547325ve___getations
venerations14411315ve___nerations
verifications21159975ve_rifications
vociferations2153115_vociferations

Search took 7 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 Filter178691950240.373479064.3
2DLD Change Limit950241975.76616480.1
3Display Results1971970.1401407.1
 (SQL Overall)1786911976.27928458.5
 
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.