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

147 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
commiserating205319(None) 
commiseratingly2571262commiseratingly
commiseration1964042commiseration
commiserations2053452commiserations
commiserative2283272commiserative
commemorating1953073commemorating
commiserate1753893commiserat__e
commiserated1963063commiserat_ed
commiserates1853603commiserat_es
commentating1957044comm_entating
commenting1749174comm__e_nting
commercing1955974comm__er_cing
comminuting1844504commi__nuting
commissioning2092624commissioning
committing1746684commi___tting
communicating2254874communicating
commutating1846024comm__utating
confederating2054014confederating
confiscating2053614confis_cating
consecrating1747944co__nsecrating
cooperating1648424co__operating
immigrating1743314_immi_grating
miseating121215434___mise_ating
misrating121014854___mis_rating
obliterating1553394_obliterating
vociferating2182454vo_ciferating
acierating1348315__aci_erating
administrating1862135administrating
alliterating1354275_alliterating
bombinating1844425bombi__nating
calibrating1645345c_ali_brating
camphorating2252565c_amphorating
caseating12311745c___ase_ating
castrating1349775c___astrating
chemisorbing2261335chemisor_bing
cocreating15310295co__cre_ating
codirecting1743635co_dire_cting
coexerting2045495co__exer_ting
coexisting2044405coexis___ting
cogitating1447215co_gi__tating
collaborating1852585collaborating
colligating1545705colli__gating
collimating1645425colli__mating
combating16310155co_m___bating
combusting1745445combus___ting
comforting18165935co_m_for_ting
commemoration1853885commemoration
commemorations1953445commemorations
commemorative2163045commemorative
commencing1946185comm__e_ncing
commending1846635comm__e_nding
commensuration20162985commensuration
commensurations21182585commensurations
commination171111645commi__nation
comminations18810485commi__nations
commingling1952825commi__ngling
commissarial1862015commis_sarial
commissariat1862535commis_sariat
commissaries1852875commis_saries
commixing2345195commi____xing
commuting16288445comm____uting
comparting17188375co_m_par_ting
compeering1747055co_mpeer__ing
compensating1955005co_mpensating
compering163414165co_m_per__ing
competing163712465co_m_pe__ting
complecting2045755co_mple_cting
completing1748415co_mple__ting
complicating2145635co_mplicating
complimenting2252865complime_nting
comporting17199165co_m_por_ting
compositing1846265compos__iting
composting17178045compos___ting
computerising2062635computerising
computerizing2952835computerizing
concatenating1853265concatenating
concelebrating2172595concelebrating
concentrating1856435concentrating
concerting15313895co__ncer_ting
conciliating1775615conci_liating
conglomerating2062425conglomerating
congregating1754285co_ngregating
consenting13313215co__nse_nting
conserving1639755co__nser_ving
consideration1655525consideration
considerations1764845considerations
considering1544845consider__ing
consisting1349525consis___ting
consorting13410745co__nsor_ting
consternating1654975co_nsternating
converting16313135co__nver_ting
copresenting1754945coprese_nting
corelating13511585co___relating
correlating1487085co__rrelating
corroborating1862435corroborating
corseting12312175co__rse__ting
coruscating1644695co_rus_cating
cosseting1239545co__sse__ting
counteracting1856285co_unteracting
criminating1646855crimi__nating
culminating1645735culmi__nating
deliberating1645125_deliberating
demonstrating17104765demonstrating
desiderating1544695_desiderating
disrating11714555___dis_rating
dominating1449405do_mi__nating
emigrating1467505__emi_grating
enumerating1445005enum__erating
eviscerating1852675__eviscerating
incinerating1554725_incinerating
iterating10314255____iterating
itinerating1245235__itinerating
liberating1349255___liberating
macerating1549535___macerating
migrating13910535___mi_grating
miscreating1648495___miscreating
misdating131010665___mis_dating
misdrawing1745805___misdrawing
misediting1446575___misediting
misframing1846235___misframing
misgrading1546825___misgrading
misgrafting1844085___misgrafting
mismating141211825___mis_mating
misparting1538085___misparting
misreading1448265___misreading
misrelating1447275___misrelating
misseating131310945___misseating
misstating13129315___misstating
mistracing1569605___mistracing
mistreating1449285___mistreating
miswriting1646845___miswriting
moderating1448805___moderating
noisemaking1852565no__isemaking
nominating1349505no_mi__nating
nonoperating1555415no_noperating
numerating1357235_num__erating
obsecrating1644135_o__bsecrating
operating12313725_o___perating
proliferating1962365proliferating
refrigerating1853185refrigerating
reiterating12410495__reiterating
remigrating1547595_remi_grating
remonstrating1695555remonstrating
remunerating1545425_remunerating
somerseting1453065somerse__ting
somersetting1552185somerse_tting
tolerating1148595to___lerating

Search took 9 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.1431249587.4
2DLD Change Limit1247901478.09315419.5
3Display Results1471470.0931580.6
 (SQL Overall)1786911478.32921454.1
 
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.