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

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

160 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
coexist163858(None) 
coexists1735651coexists
chemist143615002chemist
coedit9316242coedi_t
coedits10310242coedits
coexert16312362coexert
coexisted1944142coexisted
consist9316032consist
copyist1439052copyist
cosmist11311332cosmist
exist124618942__exist
sexist133013482_sexist
ageist7315383age_ist
aorist64827873ao_rist
bemist105216953_bemist
boxiest163711983bo_xiest
cambist13312113cambist
canoeist10310693canoe_ist
casuist9411303casuist
cedis84317083c_edis_
cellist9314423cellist
cerise84822043c_erise
chemise143211503chemise
chemism16339303chemism
chemists152710323chemists
cherish15310463cherish
chest104926143che__st
cheviot1546933cheviot
chewiest16177293chewiest
chutist1239453chutist
chymist17268173chymist
cist67244963c___ist
cladist10311973cladist
clerisy1246823clerisy
clevis1158963clevis_
coaliest10316223coaliest
coassist10298803coassist
coast75236273co__ast
coatis85122603coatis_
coaxes154715633coaxes_
coaxial16157003coaxial
coaxing173511703coaxing
cobbiest14118523cobbiest
cockiest163013293cockiest
cockish1838503cockish
codfish1637163codfish
coeds85920163coe_ds_
coeliac1138233coeliac
coempt12311033coe_mpt
coempts1335683coempts
coenact11311803coenact
coerect11913353coerect
coesite9713623coesite
coexerts1734883coexerts
coexistent1984243coexistent
coexisting2044403coexisting
cognise1059683cognise
cohost115217213co_host
coldest102514763coldest
coldish1399303coldish
colonist102617933colonist
colorist102818993colorist
coltish121310933coltish
combust1338363combust
comeliest13410033comeliest
comfiest1539133comfiest
comfit133112423comfi_t
comfits14328743comfits
commit124016703commi_t
commits133812383commits
commixt20357623commixt
compost134515353compost
concise11314473concise
confit113316403confi_t
confits122811423confits
congest104618773congest
consists10310593consists
contest93523233contest
convict143410983convict
coolest9318643coolest
coolish12312523coolish
copyists1545993copyists
corgis9314413corgis_
corkiest143114793corkiest
cornetist1149763cornetist
corniest102117303corniest
cosiest93819853cosiest
cosmism1337013cosmism
cosmists1237993cosmists
cost68057943co___st
couldst1037043couldst
coulis84018763coulis_
cowfish1836433cowfish
cowiest123614673cowiest
coxes145430863co_xes_
coxing164218863co_xing
coyest11316053co_yest
coyish143710393co_yish
coziest184014353coziest
credit9315193credi_t
credits1039973credits
crepiest12310383crepiest
crest74632693cre__st
cubist104214443c_ubist
cultist91412713cultist
cyclist1438853cyclist
cyesis1148573cyesis_
czarist18710223czarist
deist64633593_de_ist
delist74625053_delist
desist74818813_desist
doest65829523doe__st
duelist8511413duelist
elegist81311973elegist
epeeist938863epeeist
exists134710913__exists
exit114428673__exi_t
exits125515913__exits
feist86230073_fe_ist
foist85730973fo__ist
foxiest174310493fo_xiest
heist87030913_he_ist
hoist86433213ho__ist
holist94723213ho_list
hornist102314823hornist
joist125125653jo__ist
legist71315253_legist
lexis125916033_lexis_
lookist1139563lookist
modelist11310503modelist
moist76033583mo__ist
monist84324983mo_nist
neist54628443_ne_ist
noesis6311443noesis_
nonsexist1645313nonsexist
novelist1149453novelist
oboist8312683_oboist
oculist9310883oculist
odist6421913_o_dist
pietist9414033pietist
plenist9314333plenist
poetise9314043poetise
polemist12412363polemist
pollist9816603pollist
poloist91016323poloist
poxiest163412253po_xiest
preexist1747963preexist
querist16311133querist
relist64628413_relist
resist64524533_resist
sexiest142112223_sexiest
sexism15227653_sexism
sexists14267673_sexists
solecist10910783solecist
soloist7915893soloist
sophist12311563sophist
theist9314763the_ist
totemist1049033totemist
tourist7313203tourist
verist93823893_verist

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 Filter1786911340270.1531167915.0
2DLD Change Limit1340271606.87619492.0
3Display Results1601600.0632539.7
 (SQL Overall)1786911607.09225196.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.