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

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

103 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
regulations1231071(None) 
regulation11312051regulation_
angulations1268052angulations
crenulations1446492crenulations
deregulations1545202deregulations
emulations12310942_emulations
peculations15310282peculations
reflations13311232re_flations
refutations1448672refutations
regulating12310062regulati_ng
regulators1146502regulat_ors
relations92418332re__lations
reputations13410732reputations
reregulations1455712reregulations
revelations14410302revelations
adulations11310123_adulations
ambulations1547113ambulations
angulation1149553angulation_
annulations1167833annulations
coagulations1546513coagulations
copulations151111113copulations
crenelations1446183crenelations
crenulation1347573crenulation_
cumulations1547433cumulations
dealations11311373de_alations
deflations1439713de_flations
degustations1444833degustations
delations102616593de__lations
denudations1346343denudations
depilations14310903depilations
deputations1448343deputations
deregulation1446083deregulation_
desolations12310593desolations
educations1339233_educations
elations83719123_e__lations
emulation11312393_emulation_
epilations12311713_epilations
equations1839493_equ_ations
exudations18107073_exudations
exultations1846523_exultations
fellations1338063fe_llations
figurations1545083figurations
gelations102513093__gelations
granulations1345783granulations
gratulations1345173gratulations
insulations11310233insulations
legations102711923leg__ations
legislations1343753legislations
lobulations1346213lobulations
maculations1569623maculations
modulations14147263modulations
morulations13148163morulations
negations102811963neg__ations
neurulations1244733neurulations
nodulations12147003nodulations
osculations1348373osculations
ovulations1337973_ovulations
peculation14311993peculation_
populations15148713populations
recitations13314203recitations
recreations13412253recreations
reductions1359583redu_ctions
reeducations1545473reeducations
reflation12412333re_flation_
refutation1349913refutation_
regelating1239953regelati_ng
regularizes2144793regularizes
regulates101211723regulat__es
regulative1446983regulati_ve
regulator1046973regulat_o_r
regulatory1445293regulat_ory
reinflations1546643reinflations
relation82619773re__lation_
relaxations1845643relaxations
relegations1248973relegations
relocations13311143relocations
reluctations1446753reluctations
renovations1448423renovations
reparations13611663reparations
repletions1247473re_pletions
repopulations1765333repopulations
repudiations1597033repudiations
repulsions1244793repul_sions
reputation12411883reputation_
reregulation1346413reregulation_
resolutions11117793resolutions
restations10315843re_stations
resumptions15154593resumptions
retaliations12511403retaliations
reticulations1556613reticulations
revaluations1557633revaluations
revelation13410923revelation_
revocations16410313revocations
revolutions1497633revolutions
revulsions1344263revul_sions
rogations101510823rog__ations
simulations1368393simulations
speculations1646393speculations
tabulations1346853tabulations
tribulations1445463tribulations
ululations1037143_ululations
undulations1246053undulations
vegetations1547323vegetations

Search took 6 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 Filter1786911216330.406440125.6
2DLD Change Limit1216331035.12623728.6
3Display Results1031030.0462239.1
 (SQL Overall)1786911035.57832035.0
 
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.