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

258 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
coltish12131093(None) 
coldish1399301coldish
cultish12139111cultish
doltish11118731doltish
cattish12410722cattish
coalfish1635492coalfish
coatis85122602coatis_
cockish1838502cockish
codfish1637162codfish
colitis92617352colitis_
coltishly1744212coltishly
colts76633292colt_s_
coolish12312522coolish
cowfish1836432cowfish
coyish143710392co_yish
cultism11158002cultism
cultist91412712cultist
dollish11610092dollish
folkish1736562folkish
goatish1139562goatish
hottish13117902hottish
loutish1039962loutish
oldish10169312_oldish
polish114916722pol_ish
saltish10312162saltish
softish13127812softish
sottish10129442sottish
wolfish1636932wolfish
abolish12311503abol_ish
baldish1339503baldish
bluish1159243_bluish
boarish123911913boarish
boggish14238653boggish
bolting104416763bolting
bolts76232113bolt_s_
boobish14338943boobish
bookish163610023bookish
boorish123712593boorish
boxfish2285543boxfish
boyish142911233bo_yish
brutish1237703brutish
bullish12511193bullish
caddish143810123caddish
calash11312433cal_ash
caliph13311403cal_iph
carlish12312763carlish
catfish1559023catfish
cellist9314423cellist
celts75325783celt_s_
ceorlish1345383ceorlish
cherish15310463cherish
childish1744393childish
chutist1239453chutist
clash106219033c_l_ash
clayish1547943clayish
cloddish1544233cloddish
clonism1138983clonism
cloth105817543clot__h
cloths115512483cloths_
clots75627643clot_s_
clownish1643803clownish
coati75624643coati__
coating103525313coating
coats75635003coat_s_
coexist1638583coexist
cognise1059683cognise
cohosh14517123co_hosh
coition9314313coition
coitus8511893coitus_
colas75436773col_as_
colbys13407153colbys_
coldest102514763coldest
colds85726973col_ds_
coles76055063col_es_
coleus86818273coleus_
colic95726173col_i_c
colics104219903col_ics
colies84837053col_ies
colin76231693col_i_n
colins85229043col_ins
colitic112916193colitic
colitises11311743colitises
collide103214793collide
collie83621993colli_e
collied103316673collied
collier93618153collier
collies94326583collies
collins93419833collins
cologs96517353cologs_
colonise102514283colonise
colonist102617933colonist
colons86028683colons_
colorism122112433colorism
colorist102818993colorist
colors86622373colors_
colossi935673colossi
colpitis1247503colpitis_
cols66553083col__s_
colt67158243colt___
colter84625093colt_er
colters93522443colters
colzas174010513colzas_
comtes106222813comtes_
concise11314473concise
consist9316033consist
contes84432913contes_
contest93523233contest
contos84923233contos_
contuse9311413contuse
coolth1139513coolt__h
coolths1236013coolths_
cootie84223093cooti_e
cooties93725733cooties
coots75636843coot_s_
copyist1439053copyist
corgis9314413corgis_
cortin82423153corti_n
cortina91915973cortina
cortins92421333cortins
cortisol1045403cortisol
cosh96127623co___sh
cosmism1337013cosmism
cosmist11311333cosmist
costing104323023costing
costive12312843costive
costs77231143cost_s_
cotes76347843co_tes_
coting94629253co_ting
cots68054843co_t_s_
cottas84615573cottas_
cottier93814173cottier
coulis84018763coulis_
couth106122493cout__h
couths115715413couths_
coxitis16238463coxitis_
cronish12310863cronish
cubbish1635803cubbish
cuish10313173c__uish
cullis84115993cullis_
cultch13385953cult_ch
culti76317253culti__
cultic105111903culti_c
cultishly1744073cultishly
cultisms12126713cultisms
cultists10107633cultists
cults75022553cult_s_
cultus85110733cultus_
currish1238353currish
cutis77723763c_utis_
delish105215613del_ish
dogfish15226763dogfish
doggish13237533doggish
doltishly1643383doltishly
dolts65626313dolt_s_
donnish11187633donnish
dovish1338103do_vish
dullish1148743dullish
elfish1267963_elfish
elvish1277563_elvish
eolith93013903eol_ith
eoliths10318573eoliths
fattish1359263fattish
fetish12310373_fetish
fluish1239333_fluish
fogyish1735363fogyish
follis93113903follis_
foolfish1744393foolfish
foolish1339613foolish
foppish1735103foppish
fortis95418613fortis_
fortyish1744843fortyish
foxfish2354483foxfish
goatfish1544293goatfish
goldfish1644203goldfish
golosh1036463gol_osh
goodish1237963goodish
goyish13379013go_yish
hellish13310723hellish
hogfish17257023hogfish
hoggish15247593hoggish
holism113713753hol_ism
holist94723213hol_ist
holts85627913holt_s_
joltier14318493joltier
joltiest15249403joltiest
joltily1746323joltily
jolting153410913jolting
jolts125018883jolt_s_
latish92416173_latish
leftish13197253leftish
loggish12258723loggish
longish11229093longish
loudish1137983loudish
lowish12310533lo_wish
mobbish1635923mobbish
modish123813543mo_dish
molting103517173molting
molts76032093molt_s_
monish114217593mo_nish
monkish1638243monkish
moonish123311043moonish
moorish123311783moorish
mopish134311593mo_pish
mortise9713533mortise
mulish11311903mul_ish
noirish1037883noirish
nourish1039703nourish
oafish121311723_oafish
oddish11107653_oddish
offish15137273_offish
ogrish1039263_ogrish
oolith93813243ool_ith
ooliths10268323ooliths
outfish132210573_outfish
outwish13289853_outwish
owlish1238703_owlish
palish114718273pal_ish
pettish1238283pettish
poetise9314043poetise
poleis86018353poleis_
polis74731163pol_is_
pollist9816603pollist
poloist91016323poloist
poorish123712303poorish
popish133812113po_pish
potash1138273po_tash
rattish10510823rattish
relish93916953rel_ish
roguish1156833roguish
rompish1436693rompish
rotis56327063ro_tis_
runtish1048693runtish
ruttish1048303ruttish
selfish1388513selfish
shortish1437423shortish
slowish1337633slowish
snoutish1145783snoutish
soloist7915893soloist
sourish10310693sourish
stoutish1145903stoutish
tallish103313583tallish
tartish101512633tartish
toadish1139063toadish
tonish93415903to_nish
tonnish10149093tonnish
townish13167933townish
toyish122911123to_yish
voguish1465203voguish
voltaism1344813voltaism
voltes94915583voltes_
volti84915963volti__
volts85421293volt_s_
wettish1335963wettish
whitish1635973whitish
wildish1446853wildish
woggish15276673woggish
wolffish2043333wolffish
wormish1537163wormish

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.420425454.8
2DLD Change Limit1340272586.50020619.5
3Display Results2582580.0962687.5
 (SQL Overall)1786912587.01625469.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.