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

112 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
consociates154654(None) 
consociate1446851consociate_
consociated1645211consociated
consecrates1548392consecrates
consolidates1563862consolidates
associates12115883_associates
collocates1448123colloc_ates
colocates13312853co_loc_ates
conciliates1546883conciliates
consecrate1448433consecrate_
consecrated1646913consecrated
consociating1755573consociating
consociation1648193consociation
consociations1747513consociations
consolidate1463783consolidate_
consolidated1663313consolidated
constipates1546353constipates
consulates12711103cons_ulates
consummates1754203consummates
dissociates1455783dissociates
annunciates13112654annunciates
associate11116024_associate_
associated13114704_associated
cenobites1346204cen_obi_tes
coelomates1497564coelo_mates
coenobites1444184coenobi_tes
coenocytes1744094coenoc_ytes
coesites101313094coes__i_tes
cohobates1646524co_ho_bates
collocate1348664colloc_ate_
collocated1546164colloc_ated
colocate12313434co_loc_ate_
colocated1439614co_loc_ated
complicates1947054complicates
composites1648904composi_tes
concaves1538904con__c_aves
conciliate1447524conciliate_
conciliated1645644conciliated
conclaves1646544con__claves
concocted1346764concoc__ted
concocter1247624concoc__ter
concocters1346754concoc__ters
concocts1138634concoc__t_s
concordats1544194concordat_s
concretes13411474con__cretes
condensates1445314condensates
conepates13912284con__epates
confiscates1854044confiscates
conflates14311134con__flates
conglobates1653324conglobates
congregates1545504congregates
conicities14412634con_icities
conjugates2044694con_jugates
connotes10311454conno___tes
conominees1445924con_ominees
consciences1447024cons_ciences
conscious1347594cons_ci_ous
consciouses1554564cons_ciouses
conscribes1645194cons_cribes
conscripted1853434conscripted
conscripts1644594conscript_s
consecrator1546384consecrator
consecrators1656054consecrators
consisted1238504cons__isted
consists10310594cons__ist_s
consoles103216154conso___les
consolidator1553284consolidator
consolidators1653294consolidators
consommes1545634conso__mmes
consonances1545774consonances
consonants1246484conso_nants
consorted1239774conso__rted
consorts101512344conso__rt_s
conspires1358484cons_pi_res
constellates14174234constellates
consternates1455054consternates
constipate1446394constipate_
constipated1645464constipated
constitutes1376164constitutes
constricted1646364constricted
constricts1477734constrict_s
constringes1445044constringes
consulate11612234cons_ulate_
consummate1654264consummate_
consummated1853494consummated
contaminates1656314contaminates
convolutes1544504convo_lutes
coprolites1448224coproli_tes
coronates1110816924co_ro_nates
corotates112714284co_ro_tates
corporates14410734corpo_rates
coruscates1445684corusc_ates
covariates1545784co_variates
deconsecrates1894044deconsecrates
dissociate1346514dissociate_
dissociated1555604dissociated
enunciates1245134_enunciates
gonocytes1544734gon_oc_ytes
insolates9311274_inso_lates
invocates1447644_invoc_ates
monocrats1348534mon_ocrat_s
monocytes1647974mon_oc_ytes
monzonites2144304monzoni_tes
nonassociated1662224nonassociated
nonsocial1148204nonsocia__l
nonsocialist1474454nonsocialist
noviciates1543764no_viciates
obsecrates1444584_obsecrates
officiates1843694_officiates
reconsecrates1784424reconsecrates
reconsolidates17122224reconsolidates
sonicates11410384son_ic_ates

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 Filter1786911488190.1531167915.0
2DLD Change Limit1488191129.36015899.5
3Display Results1121120.0631777.8
 (SQL Overall)1786911129.57618660.3
 
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.