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

90 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
deregulating155401(None) 
reregulating1454641reregulating
deregulation1446082deregulation
deregulations1545202deregulations
regulating12310062__regulating
delegating1337673deleg__ating
demodulating1753163demodulating
depopulating1853733depopulating
deregulate12135193deregulat__e
deregulated14134733deregulat_ed
deregulates13135133deregulat_es
derogating1348633derog__ating
overregulating1963793overregulating
regelating1239953__regelating
reregulation1346413reregulation
reregulations1455713reregulations
angulating1247824__angulating
cerebrating1646664cere_brating
circulating1647734cir_culating
coagulating1545074_coagulating
corelating13511584core__lating
crenelating1445514_crenelating
deaerating12311564deae__rating
decelerating1645594decelerating
decollating1545974de_collating
decrepitating1953024decrepitating
defaulting1543394de_faul_ting
defeating142311974defe___ating
defecating17237784defe__cating
deflating142610714d__e_flating
degenerating1545664degenerating
deglazing2135134d__eg_lazing
degusting1236164d__egu_sting
delating103119604d__e__lating
delectating1545994dele_ctating
denervating1645924dene_rvating
denigrating14146924denig_rating
denudating1345264d__enudating
depilating1439194d__epilating
deprecating1777284depre__cating
depreciating1845044depre_ciating
depredating1655694depre__dating
depurating1438644d__epurating
deracinating1645224deracinating
derating103222284der____ating
desecrating1548094dese_crating
desegregating1752734desegregating
designating1446074desig_nating
desolating1239464d__esolating
despumating1743694de_spumating
devaluating1645054devalu_ating
ejaculating2144834_ejaculating
emulating1239874___emulating
formulating1765054for_mulating
granulating1345294_granulating
gratulating1344724_gratulating
jugulating1943844__jugulating
mercurating1645954mer_curating
overeducating2054854overeducating
peculating1549164__peculating
perambulating2052524perambulating
percolating1657324per_colating
peregrinating1752974peregrinating
perennating1445544pere_nnating
perpetuating1753804perpetu_ating
reeducating1545164re_educating
reflating132514714__re_flating
reglazing2046554__reg_lazing
regrating111316214__reg_rating
regulation11312054__regulation
regulations12310714__regulations
regulative1446984__regulative
relating92725444__re__lating
relegating1239484releg__ating
replating122217404__re_plating
repopulating1744484repopulating
reregulate11145954reregulat__e
reregulated13135404reregulat_ed
reregulates12135804reregulat_es
rerepeating1447184rere_peating
reslating102516994__re_slating
resulting10311084__resul_ting
reticulating1546394reticulating
revegetating1753684revegetating
segregating1445454segreg__ating
speculating1645944_speculating
strangulating1583264strangulating
stridulating1453514stridulating
tribulating1445354_tribulating
vesiculating1844674vesiculating

Search took 8 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 Limit124790907.12317519.3
3Display Results90900.0501800.0
 (SQL Overall)178691907.56323627.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.