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

292 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
consist931603(None) 
consists10310591consists
coassist10298802coassist
coexist1638582coexist
concise11314472concise
confit113316402confi_t
confits122811422confits
congest104618772congest
consent93723112consent
consign1038772consign
consisted1238512consisted
consort91319902consort
consult92513632consult
contest93523232contest
convict143410982convict
copyist1439052copyist
cosiest93819852co_siest
cosmist11311332cosmist
insist6314512_insist
monist84324982mon_ist
sonsiest8313032sonsiest
agonist82615403agon_ist
aorist64827873ao_rist
assist6314603_assist
bassist9312743bassist
bongoist1147643bongoist
boniest93318993boniest
bonniest10310773bonniest
bossiest103112213bossiest
bossism1136063bossism
bundist10310193bundist
cambist13312113cambist
canniest10313363canniest
canoeist10310693canoeist
canonist10513533canonist
cansos84915383cansos_
canst74932213can__st
cassis84818853cassis_
casuist9411303casuist
cellist9314423cellist
censes83721803censes_
censing104215263censing
census84310303census_
centrist10314863centrist
chemist143615003chemist
choosiest1437323choosiest
chutist1239453chutist
chymist17268173chymist
cineast9310523cineast
cist67244963c___ist
cladist10311973cladist
classist104010383classist
clonism1138983clon_ism
closest94312533closest
coaliest10316223coaliest
coarsest1039163coarsest
coassists11275763coassists
coast75236273co__ast
coasts85719143coasts_
coatis85122603coatis_
cobbiest14118523cobbiest
cockiest163013293cockiest
cockish1838503cockish
codfish1637163codfish
coedit9316243coedi_t
coedits10310243coedits
coesite9713623coesite
coexists1735653coexists
cognise1059683cognise
cohost115217213co_host
coldest102514763coldest
coldish1399303coldish
colonist102617933colonist
colorist102818993colorist
coltish121310933coltish
combust1338363combust
comfiest1539133comfiest
comfit133112423comfi_t
comfits14328743comfits
commit124016703commi_t
commits133812383commits
commixt20357623commixt
compost134515353compost
conceit113218073conceit
conceits122813613conceits
concent114422513concent
concept133314443concept
concert113325223concert
conchs134714903conchs_
conciser12310243conciser
concisest1348253concisest
concoct10312903concoct
concuss1138063concuss
condign1147733condign
condos94322333condos_
conduct121411593conduct
conduit10713083conduit
conduits111210063conduits
cones76457423con_es_
coneys115218423coneys_
confect143614273confect
confess12399903confess
confide13310203confide
confine12315583confine
confirm1437363confirm
conflict1547753conflict
confuse1238853confuse
congas94417033congas_
conges94928173conges_
congests113510383congests
congii957363congi_i
congius103210073congius
congos94219883congos_
coni65534803con_i__
conic95329793con_i_c
conics103920593con_ics
conies84338593con_ies
coniine9316803coniine
conin76232723con_i_n
conine84528553con_ine
coning94331823con_ing
conins84327233con_ins
coniosis1048143coniosis_
conium10415313con_ium
conjoint17410373conjoint
conking143618453conking
conks115525703con_ks_
connect113515743connect
conning103718753conning
connive1238993connive
conns75024233con_ns_
conoid9818883conoi_d
conoids10813883conoids
conquest1939553conquest
cons66057693con__s_
conscript1547123conscript
consents102715893consents
consider11310393consider
consigns1137533consigns
consistent1248553consistent
consisting1349523consisting
consistory1545573consistory
consol82614113cons_ol
console92715983console
consols92914073consols
consorts101512343consorts
conspire1257873conspire
constant10515593constant
constrict13711623constrict
consul82312303cons_ul
consuls92412323consuls
consults10219983consults
consume11510133consume
contact1144020683contact
content94326153content
contes84432913contes_
contests103413383contests
context163913433context
contort91422343contort
contos84923233contos_
contrast102614783contrast
contuse9311413contuse
conus76726533con_us_
convect143114483convect
convent123919413convent
convert123721473convert
convicts15337713convicts
coolest9318643coolest
coolish12312523coolish
copses104922483copses_
copyists1545993copyists
corgis9314413corgis_
corkiest143114793corkiest
cornetist1149763cornetist
corniest102117303corniest
corses84433463corses_
corset85636223cors_et
corsets94819803corsets
corslet9318063corslet
coses76949493co_ses_
coset75748843co_s_et
cosets85824403co_sets
cosie74728273co_si_e
cosied94819893co_sied
cosier84423763co_sier
cosies84932163co_sies
cosign958783co_sign
cosily113613853co_sily
cosine83823513co_sine
cosmism1337013cosmism
cosmists1237993cosmists
coss66143493co_s_s_
cosset84125863co_sset
cossets95014283cossets
cost68057943co___st
costs77231143co_sts_
couldst1037043couldst
coulis84018763coulis_
cousin8517163cousi_n
cousins9516003cousins
cowfish1836433cowfish
cowiest123614673cowiest
coyest11316053co_yest
coyish143710393co_yish
coziest184014353coziest
crasis85020473crasis_
crisis83716343crisis_
cronish12310863cron_ish
cronyism1544723cronyism
crossest1012012123crossest
cubist104214443c_ubist
cultist91412713cultist
cyclist1438853cyclist
cyesis1148573cyesis_
czarist18710223czarist
densest83112473densest
dentist8316743dentist
desist74818813_desist
donnish11187633donnish
donsie7613643donsi_e
economist1348883economist
enlist6417043_enlist
enosis63816423enosis_
eonism83213533eon_ism
foist85730973fo__ist
fondest11312403fondest
gnomist1049133gnomist
gnosis75711213gnosis_
goosiest92911823goosiest
gorsiest92511133gorsiest
hoist86433213ho__ist
holist94723213ho_list
honest94822423hon_est
hornist102314823hornist
horsiest112513263horsiest
insists739083_insists
ionise63516943ion_ise
ironist7314843iron_ist
joist125125653jo__ist
longest84114953longest
longish11229093longish
lookist1139563lookist
loosest75811563loosest
lousiest82311613lousiest
moist76033583mo__ist
mongst93512603mon_gst
monish114217593mon_ish
monism104016313mon_ism
monists93614783mon_ists
monkish1638243monkish
monodist11310923monodist
mossiest103112443mossiest
mousiest102711763mousiest
neist54628443__neist
noesis6311443noesis_
noisiest839763noisiest
nonpast939033nonpast
nonsexist1645313nonsexist
nonsuit7811343nonsuit
nonsuits869153nonsuits
nosiest73415673no_siest
oasis56422553_oasis_
oboist8312683_oboist
oculist9310883oculist
odist6421913_o_dist
onanist7314633_onanist
onset54730173_ons_et
onsets64013543_onsets
onside7511803_onside
persist9315853persist
pollist9816603pollist
poloist91016323poloist
posit75833333po_si_t
posits85718713po_sits
resist64524533_resist
rosiest73919213ro_siest
soloist7915893soloist
sonsie6614863sonsi_e
sonsier7711743sonsier
sophist12311573sophist
subsist9311573subsist
tanist6324603tan_ist
tennist72813113tennist
tensest72713313tensest
toniest73218903toniest
tonish93415903ton_ish
tonnish10149093tonnish
tonsil6311873tonsi_l
tonsils7310183tonsils
tourist7313203tourist
wonkiest1538943wonkiest
yonis85020823yon_is_

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.403443402.0
2DLD Change Limit1340272926.50020619.5
3Display Results2922920.1102654.5
 (SQL Overall)1786912927.01325480.0
 
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.