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

98 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
reregulations145570(None) 
deregulations1545191deregulations
reregulation1346411reregulation_
deregulation1446082deregulation_
regulations12310712__regulations
reregulating1454642reregulati_ng
crenulations1446493_crenulations
deregulating1554013deregulati_ng
overregulations1963823overregulations
reeducations1545463re_educations
regulation11312053__regulation_
relegations1248973releg__ations
repopulations1765323repopulations
reregulates12135783reregulat__es
reticulations1556613reticulations
revegetations17114713revegetations
revelations14410303reve__lations
angulations1268054__angulations
cerebrations1646934cere_brations
circulations1648474cir_culations
coagulations1546504_coagulations
crenelations1446184_crenelations
crenellations1553574crene_llations
crenulation1347574_crenulation_
degranulations1652744degranulations
delegations1348034deleg__ations
demodulations1754144demodulations
denegations1348544deneg__ations
depopulations1844494depopulations
deregulates13135114deregulat__es
derogations1349384derog__ations
ejaculations2195214_ejaculations
emulations12310944___emulations
formulations1745624for_mulations
granulations1345784_granulations
gratulations1345174_gratulations
mercurations1646534mer_curations
morulations13148154mor__ulations
neurulations1244734ne_urulations
nonregulation1473904nonregulation_
osmoregulations1861724osmoregulations
overeducations2054954overeducations
overregulation1864324overregulation_
peculations15310274__peculations
perambulations2053054perambulations
percolations1648024per_colations
peregrinations17114684peregrinations
perennations1447224pere_nnations
permutations1646504per_mutations
perpetuations1754974perpetu_ations
prefigurations2053024prefigurations
recalculations18104034recalculations
recirculations1884224recirculations
recreations13412234recre___ations
redecorations1645054redecorations
rededications1746114rededications
reeducation1445934re_education_
reescalations1573784reescalations
reevaluations1654274re_evaluations
reflations13311234__re_flations
reformulations1953554reformulations
refrigerations1863774refrigerations
refutations1448674__refutations
regenerations1447134regenerations
regulating12310064__regulati_ng
regulators1146484__regulat_ors
reinflations1546644re_inflations
reinoculations1653924reinoculations
relations92418334__re__lations
relegation11610024releg__ation_
remediations1548274reme_diations
remigrations15227794remig_rations
renaturations1355954renaturations
renegotiations15113374renegotiations
reoccupations1972764reoccupations
repopulation1656104repopulation_
reputations13410734__reputations
reradiations1349494rer_adiations
reregistrations1672824reregistrations
reregulate11145954reregulat___e
reregulated13135404reregulat__ed
resegregations1653694resegregations
reservations1588584rese_rvations
resignations1346874resig_nations
restimulations1654644restimulations
reticulation1448054reticulation_
retranslations1454204retranslations
revaluations1557634revalu_ations
revegetation16105304revegetation_
revelation13410924reve__lation_
segregations1445804segreg__ations
speculations1646394_speculations
strangulations1563654strangulations
stridulations1454394stridulations
triangulations1552304triangulations
tribulations1445444_tribulations
vermiculations2153884vermiculations
vesiculations1845314vesiculations

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.1261418182.5
2DLD Change Limit95024986.04615716.8
3Display Results98980.0631555.6
 (SQL Overall)178691986.23528659.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.