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

243 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
coldish139930(None) 
coltish121310931coltish
oldish10169311_oldish
baldish1339502baldish
caddish143810122caddish
childish1744392childish
cloddish1544232cloddish
coalfish1635492coalfish
cockish1838502cockish
codfish1637162codfish
coldest102514762coldest
colds85726972cold_s_
coolish12312522coolish
cowfish1836432cowfish
coyish143710392co_yish
cultish12139112cultish
dollish11610092dollish
doltish11118732doltish
folkish1736562folkish
goldfish1644202goldfish
goodish1237962goodish
loudish1137982loudish
modish123813542mo_dish
oddish11107652_oddish
polish114916722pol_ish
toadish1139062toadish
wildish1446852wildish
wolfish1636932wolfish
abolish12311503abol_ish
blondish1476173blondish
bluish1159243_bluish
boarish123911913boarish
boggish14238653boggish
boldest102613063boldest
bolds85825283bold_s_
boobish14338943boobish
bookish163610023bookish
boorish123712593boorish
boxfish2285543boxfish
boyish142911233bo_yish
broadish1446933broadish
bullish12511193bullish
caddis104613383caddis_
cadis84428503c_adis_
calash11312433cal_ash
caliph13311403cal_iph
carlish12312763carlish
catfish1559023catfish
cattish12410723cattish
cedis84317083c_edis_
cellist9314423cellist
ceorlish1345383ceorlish
cherish15310463cherish
cladism1238553cladism
cladist10311973cladist
clash106219033c_l_ash
clayish1547943clayish
clods85320863clod_s_
clonism1138983clonism
clownish1643803clownish
coatis85122603coatis_
codas84724243co_das_
codding124014693codding
codes86247293co_des_
codify1537163co_dify
coding104024793co_ding
codlin94516443codli_n
codling114418953codling
codlins104116243codlins
cods76848103co_d_s_
coedit9316243coedi_t
coedits10310243coedits
coeds85920163coed_s_
coexist1638583coexist
cognise1059683cognise
cohosh14517123co_hosh
colas75436773col_as_
colbys13407153colbys_
cold77338773cold___
colder95121843cold_er
coldly12459953cold_ly
coldness1137953coldness
coles76055063col_es_
coleus86818273coleus_
colic95726173col_i_c
colics104219903col_ics
colies84837053col_ies
colin76231693col_i_n
colins85229043col_ins
colitis92617353colitis_
collide103214783collide
collie83621993colli_e
collied103316673collied
collier93618153collier
collies94326583collies
collins93419833collins
cologs96517353cologs_
colonise102514283colonise
colonist102617933colonist
colons86028683colons_
colorism122112433colorism
colorist102818993colorist
colors86622373colors_
colossi935673colossi
cols66553083col__s_
coltishly1744213coltishly
colts76633293col_ts_
colzas174010513colzas_
concise11314473concise
condign1147733condign
condos94322333condos_
consist9316033consist
copyist1439053copyist
cordial10312943cordial
cording113620823cording
cordite10315263cordite
cords86030623cord_s_
corgis9314413corgis_
cosh96127623co___sh
cosmism1337013cosmism
cosmist11311333cosmist
couldest1148353couldest
couldst1037043could_st
coulis84018763coulis_
cronish12310863cronish
cubbish1635803cubbish
cuish10313173c__uish
cullis84115993cullis_
cultism11158003cultism
cultist91412713cultist
currish1238353currish
delish105215613del_ish
dish86328333___dish
dogfish15226763dogfish
doggish13237533doggish
donnish11187633donnish
dovish1338103do_vish
dowdyish1952833dowdyish
dudish1148313_dudish
dullish1148743dullish
elfish1267963_elfish
elvish1277563_elvish
eolith93013903eol_ith
faddish15359003faddish
fluish1239333_fluish
fogyish1735363fogyish
folding123912443folding
folds95221693fold_s_
follis93113903follis_
foolfish1744393foolfish
foolish1339613foolish
foppish1735103foppish
foxfish2354483foxfish
goatish1139563goatish
goldest92411173goldest
golds75421313gold_s_
golosh1036463gol_osh
goyish13379013go_yish
hellish13310723hellish
hogfish17257023hogfish
hoggish15247593hoggish
holding123514283holding
holds94623243hold_s_
holism113713753hol_ism
holist94723213hol_ist
hottish13117903hottish
iodise74214943io_dise
iodism93611133io_dism
jadish17319903_jadish
kaddish16317973kaddish
kiddish16276583kiddish
laddish12299723laddish
loggish12258723loggish
longish11229093longish
loutish1039963loutish
lowish12310533lo_wish
maddish14289483maddish
maidish13239553maidish
mobbish1635923mobbish
moldier103110033moldier
moldiest11249693moldiest
molding114213753molding
molds85324833mold_s_
monish114217593mo_nish
monkish1638243monkish
moonish123311043moonish
moorish123311783moorish
mopish134311593mo_pish
mulish11311903mul_ish
nerdish1137103nerdish
noirish1037883noirish
nourish1039703nourish
oafish121311723_oafish
odist6421913_o_dist
offish15137273_offish
ogrish1039263_ogrish
oldest72114093_oldest
oldie6415473_oldi_e
oldies7314423_oldies
olds55926573_old_s_
oolith93813243ool_ith
owlish1238703_owlish
palish114718273pal_ish
poleis86018353poleis_
polis74731163pol_is_
pollist9816603pollist
poloist91016323poloist
poorish123712303poorish
popish133812113po_pish
prudish1376563prudish
radish103516913_radish
reddish1238033reddish
relish93916953rel_ish
roguish1156833roguish
rompish1436693rompish
roundish1246253roundish
rowdyish1852663rowdyish
saltish10312163saltish
scolding12278913scolding
scolds95011233scold_s_
selfish1388513selfish
slowish1337633slowish
softish13127813softish
soldi65717203soldi__
soldier82812153soldier
solids74116403solids_
soloist7915893soloist
sottish10129443sottish
sourish10310693sourish
tallish103313583tallish
toadfish1544903toadfish
toadyish1544153toadyish
tonish93415903to_nish
tonnish10149093tonnish
townish13167933townish
toyish122911123to_yish
tundish1137283tundish
voguish1465203voguish
widish13419363_widish
woggish15276673woggish
wolds95420183wold_s_
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.1561145455.1
2DLD Change Limit1340272437.03019065.0
3Display Results2432430.0932612.9
 (SQL Overall)1786912437.27924548.8
 
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.