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

157 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
consolidating175328(None) 
consociating1755572consoci_ating
consolidation1655152consolidation
consolidations1754742consolidations
reconsolidating1962012reconsolidating
conciliating1775613concili_ating
consolidate1463793consolidat__e
consolidated1663313consolidat_ed
consolidates1563863consolidat_es
consolidator1553283consolidat_or
consolidators1653293consolidators
constipating1775393cons_tipating
colligating1545704co__lligating
collimating1645424co__llimating
complicating2145634co_mplicating
conflating16410004con_fl__ating
conflicting1944724con_fli_cting
conglobating1853164con_globating
conscripting1954024conscri_pting
consecrating1747944cons_ecrating
considering1544844cons__idering
consisting1349524cons__i_sting
consociation1648194consoci_ation
consociations1747514consoci_ations
consolation13410984consol__ation
consolations1449744consol__ations
consoling12310874consol____ing
consorting13410744conso___rting
constellating1653264constellating
consternating1654974consternating
constituting1554654cons_tituting
constricting1747024constri_cting
consulting1349084consul___ting
consummating1953664cons_ummating
contaminating1854914contaminating
convoluting1744204convol__uting
insolating1149154_insol__ating
invalidating1793444_invalidating
associating1444865_associ_ating
cannulating1446005cannul__ating
cantillating1565045cantil_lating
canulating1349545can_ul__ating
castigating1546005c_as_tigating
chlorinating1854445c_hlorinating
coagulating1545075coagul__ating
coassisting1443595coas_si_sting
cocultivating2162345cocultivating
cogitating1447215c___ogitating
cohobating1845025co_ho__bating
collating12312765c___ol_lating
colliding1338585co__llid__ing
collocating1645905co__llocating
colocating1548625c___olocating
communicating2254875communicating
compositing1846265composi__ting
concatenating1853265concatenating
conceiting15311775con_cei__ting
concelebrating2172595concelebrating
concentrating1856435concentrating
conciliation1648235concili_ation
conciliations1747205concili_ations
conciliative1954165concili_ative
concluding1644915con_clud__ing
concocting1448415conco___cting
condoling13510375condol____ing
confabulating21102725confabulating
confederating2054015confederating
confiding1638335con__fid__ing
confiscating2053615con_fiscating
confounding1843265confound__ing
conglomerating2062425conglomerating
conglutinating1862425conglutinating
congregating1754285con_gregating
conjoining2046105conjo_i__ning
conjugating2244505con__jugating
connoting12310025conno____ting
conscribing1853905conscri__bing
consenting13313215cons___enting
consigning1446785cons__i_gning
consociate1446855consoci_at__e
consociated1645215consoci_at_ed
consociates1546545consoci_at_es
consociational1853545consoci_ational
consolatory1684965consol__atory
conspiration1648385cons_piration
conspirations1747725cons_pirations
conspiring1546555cons_pi__ring
constipation1648565cons_tipation
constipations1747685cons_tipations
constringing1653565constri_nging
constructing1746755cons_tructing
consultation1447475consul_tation
consultations1546935consul_tations
consultative1754785consul_tative
contemplating2054125contemplating
contorting13410105conto___rting
contradicting1954075contradicting
contributing1754305con_tributing
convicting1847585con__vi_cting
convolving1944415convol___ving
cooperating1648425co__operating
coordinating1653915co_ordinating
copulating1549375co_pul__ating
corelating13511585co_rel__ating
coronating13410175co_ro__nating
corotating1349325co_ro__tating
correlating1487085correl__ating
corroborating1862445corroborating
coscripting1843905co_scri_pting
cosmolining1653705cosmoli__ning
defoliating1645825_defoli_ating
denominating1645695den_ominating
desalinating1476315_desalinating
desolating1239465_desol__ating
dissociating1655365dissoci_ating
exfoliating2243395_exfoli_ating
fluoridating1752685_fluoridating
foliating1339255___foli_ating
holidaying1842395___holidaying
homologating1952735ho_mologating
inseminating1554555_inseminating
instigating1347155_ins_tigating
insulating1139265_insul__ating
intimidating1654745_intimidating
intoxicating2254125_intoxicating
isolating1039745__isol__ating
nidating1039785__n___idating
nominating1349505__n_ominating
nonirritating1472515nonirritating
nonoperating1555415non_operating
nonoxidizing3051815non_oxidizing
nonpolluting1552045nonpol_luting
nonrotating1246305nonro__tating
nonsuiting1147275nons_ui__ting
obligating1445805_o__bligating
obsoleting1342745_obsol__eting
oscillating1443975_o_scillating
oxidating1845055____oxidating
podsolization25165005podsolization
podsolizations26164375podsolizations
pollinating1445615po__llinating
pontificating2153765pontificating
postdating1447165po_s__tdating
reconsolidate16122295reconsolidat__e
reconsolidated18132135reconsolidat_ed
reconsolidates17122225reconsolidat_es
renominating1546425ren_ominating
revalidating1744185_revalidating
salivating1447435___salivating
solating9315595___sol__ating
soliciting1346815___soliciting
solvating1336445___sol_vating
sonicating1348315___sonicating
spoliating1366965__spoli_ating
unconsolidated1862035unconsolidat_ed
unsoldering1342675_unsol_dering
validating1545835___validating

Search took 10 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.393454684.5
2DLD Change Limit1247901578.81314159.8
3Display Results1571570.0931688.2
 (SQL Overall)1786911579.29919216.2
 
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.