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

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

107 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
desiderating154469(None) 
deliberating1645122deliberating
desideration1456392desideration
desiderations1545672desiderations
desiderative1753682desiderative
deaerating12311563de__aerating
decelerating1645593decelerating
degenerating1545663degenerating
dehydrating2043653dehyd_rating
delineating1346373deline_ating
denigrating14146923deni_grating
denitrating13128333deni_trating
desecrating1548093des_ecrating
deserting11713143des__er_ting
desiccating1744703desi_ccating
desiderata1252733desiderat__a
desiderate1246273desiderat__e
desiderated1444943desiderat_ed
desiderates1345813desiderat_es
desideratum1551173desiderat_um
designating1446073desi_gnating
deuterating1347273de_uterating
federating1548853fe__derating
reiterating12410493re_iterating
acierating1348314_aci_erating
alliterating1354274alliterating
asperating1349564_as_perating
asseverating1652274asseverating
debilitating1654114debilitating
decerebrating1953204decerebrating
decimating1648754deci__mating
decorating14312074de__corating
dedicating1539144de__dicating
defeating142311974de__fe_ating
defecating17237784de__fecating
deflagrating1852664deflagrating
delegating1337674de__legating
deliberation1546364deliberation
deliberations1645534deliberations
deliberative1854054deliberative
delivering1545174deliver__ing
demeriting1448684de__meriting
demodulating1753164demodulating
denervating1645924de__nervating
denudating1345264denud__ating
depilating1439184depi__lating
deprecating1777284de_precating
depredating1655694de_predating
depurating1438644de__purating
derating103222284____derating
desalinating1476314desalinating
desegregating1752734desegregating
deselecting1544474desele_cting
deserving1497904des__er_ving
desilvering1663304desilver__ing
desipramine1662464desi_pramine
desiring10312144desi__r__ing
desisting112810384desi___sting
desolating1239464des__olating
desperation14510114des_peration
desperations1559524des_perations
despumating1743694des_pumating
desquamating2551754desquamating
deviating14311084devi___ating
dimidiating1643994dimid_iating
disheriting1646454dis_heriting
disinheriting1853474disinheriting
disintegrating1763304disintegrating
disrating11714554d__i_srating
disseating121111784dis_se_ating
dissertating1474794dis_sertating
disserting121310854dis_ser_ting
diverting142410334d__iver_ting
emigrating1467504_emi_grating
enumerating1445004_enumerating
escheating1645884_esche_ating
estreating11710364_estre_ating
eviscerating1852674_eviscerating
exonerating1945554_exonerating
exuberating2144174_exuberating
generating12310384ge__nerating
hesitating1448004hesi__tating
ideating10311704___ide_ating
incinerating1554724incinerating
iterating10314254___iterating
itinerating1245234_itinerating
liberating1349254__liberating
meliorating1446564meli_orating
moderating1448804__moderating
obliterating1553394obliterating
perseverating1952524perseverating
recuperating1744994recuperating
refrigerating1853184refrigerating
regenerating1446334regenerating
rehydrating1944034rehyd_rating
remigrating1547594remi_grating
remunerating1545424remunerating
reoperating1449024re_operating
reseating102421534res__e_ating
resinating11313734resi__nating
resituating1247544resi_tuating
revibrating1745574revi_brating
tesselating1243844tes_selating
venerating14410054ve__nerating
vesicating1646894vesi__cating
vesiculating1844664vesiculating
vociferating2182454vociferating

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 Limit1247901076.65618748.5
3Display Results1071070.0631698.4
 (SQL Overall)1786911077.10925135.9
 
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.