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

226 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
caddish14381012(None) 
caddis104613381caddis_
faddish15359001faddish
kaddish16317971kaddish
laddish12299721laddish
maddish14289481maddish
baldish1339502baldish
caddice13327732caddice
caddie104316452caddi_e
caddied123710562caddied
caddies113718382caddies
caddised13315892caddised
caddises12329352caddises
caddishly1943332caddishly
cadis84428502ca_dis_
carlish12312762carlish
catfish1559022catfish
cattish12410722cattish
cloddish1544232cloddish
codfish1637162codfish
coldish1399302coldish
faddism14356722faddism
faddist12289642faddist
gaddis94211372gaddis_
jadish17319902ja_dish
kiddish16276582kiddish
ladyish14287822ladyish
maidish13239552maidish
oddish11107652_oddish
radish103516912ra_dish
reddish1238032reddish
addict10711203_addict
adding93914963_adding
adds67622453_add_s_
advise10139223_advise
aguish1059283_aguish
apish105116633_a_pish
aspish114810333_aspish
babyish1736513babyish
baddest112611143baddest
baddie104114033baddi_e
baddies114017873baddies
banish111416043ba_nish
batfish1558683batfish
blandish1497003blandish
brandish1469023brandish
caddices14297853caddices
caddisfly1941613caddisfly
caddy125414023cadd__y
caddying16225063caddying
cades85440733ca_des_
cadets96316513cadets_
cadges104716713cadges_
cadging123610973cadging
cadi75732183ca_di__
cadmic1338983cadmi_c
cadmium1446113cadmium
cadres94017933cadres_
cads76144523ca_d_s_
caids85226423caid_s_
calash11312433ca_lash
caliph13311403ca_liph
cambism1538033cambism
cambist13312113cambist
camisa103114323ca_misa
camise103319633ca_mise
candid104517853candi_d
candida114110253candida
candids113812693candids
candied113816023candied
candies104125613candies
canids95118133canids_
capris10415083capris_
cardia9916373cardi_a
cardiac1278813cardiac
cardiae10713703cardiae
cardias10715113cardias
carding113922433carding
cardio9915673cardi_o
cards85137933card_s_
carwash1535993carwash
cash96636283ca___sh
cassis84818853cassis_
casuist9411303casuist
caulis85320083caulis_
cavefish1974853cavefish
cavendish1892663cavendish
cedis84317083c_edis_
cherish15310463cherish
childish1744393childish
claddagh1641193claddagh
cladding1337143cladding
cladism1238553cladism
cladist10311973cladist
clannish1345263clannish
clayish1547943clayish
coalfish1635493coalfish
cockish1838503cockish
codding124014693codding
coltish121310933coltish
coolish12312523coolish
cowfish1836433cowfish
coyish143710393c_oyish
crankish1736513crankish
crawfish1944233crawfish
crayfish1944253crayfish
cronish12310863cronish
cubbish1635803cubbish
cuddie104011173cuddi_e
cuddies113313263cuddies
cuish10313173c__uish
cultish12139113cultish
currish1238353currish
dadaism1136443dadaism
dadaist9310103dadaist
daddies103414943daddies
dampish1567663dampish
dandyish1644723dandyish
danish101513793da_nish
darkish1537943darkish
dish86328333___dish
dudish1148313_dudish
faddier1237783faddier
faddiest1338113faddiest
faddishly2042923faddishly
faddisms15264983faddisms
faddists13235543faddists
fairish1338993fairish
famish14311843fa_mish
fattish1359263fattish
gaddi85211633gaddi__
gadding113411453gadding
gadids95611823gadids_
gadis74825293ga_dis_
garfish14179203garfish
garish104516923ga_rish
garnish111610843garnish
gawkish1835833gawkish
goodish1237963goodish
haddest122711993haddest
hadith13312063ha_dith
hadjis17439653hadjis_
hagfish17227613hagfish
haggish15207473haggish
haimish1537753haimish
hashish1238353hashish
hawkish2036553hawkish
headfish1845443headfish
kaddishes1844093kaddishes
kaddishim2051683kaddishim
kadis105921063ka_dis_
kiddush16242483kiddush
laddie83713173laddi_e
laddies93715053laddies
ladyfish1843803ladyfish
largish1138603largish
larkish1439083larkish
latish92416173la_tish
lavish124112983la_vish
lazyish22265853lazyish
loudish1137983loudish
maddest112311213maddest
madding123711993madding
mannish121710693mannish
marish114319053ma_rish
mawkish1935823mawkish
modish123813543_modish
mudfish1646263mudfish
nerdish1137103nerdish
oafish121311723oa_fish
oarfish13158613oarfish
oldish10169313_oldish
paddies113715723paddies
padding123412513padding
padis86227143pa_dis_
palish114718273pa_lish
panfish15229973panfish
parish115022353pa_rish
prudish1376563prudish
qadis155917853qa_dis_
radding103715003radding
raffish1658843raffish
rakish134313963ra_kish
rammish1437563rammish
rankish14510383rankish
raspish1298103raspish
ratfish1338773ratfish
rattish10510823rattish
ravish123414033ra_vish
rawish123012913ra_wish
redfish1437793redfish
saddest92412383saddest
sadis64930853sa_dis_
sadism94113493sa_dism
sadist74221353sa_dist
saltish10312163saltish
sandfish1556683sandfish
sawfish1637683sawfish
scampish1744893scampish
standish1238543standish
tallish103313583tallish
tannish101610573tannish
tarnish101611873tarnish
tartish101512633tartish
toadfish1544903toadfish
toadish1139063toadish
toadyish1544153toadyish
tundish1137283tundish
vampish1766283vampish
vanish121513213va_nish
varnish13169533varnish
waddie114013323waddi_e
waddied13358563waddied
waddies124214753waddies
wadding133711943wadding
wadis95223963wa_dis_
waggish15207073waggish
waifish1637703waifish
wampish1777293wampish
warmish1538373warmish
waspish1586923waspish
widish13419363_widish
wildish1446853wildish
zaddick2442993zaddick
zaddik2134243zaddi_k
zanyish2235903zanyish

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.406440125.6
2DLD Change Limit1340272266.86019537.5
3Display Results2262260.0762973.7
 (SQL Overall)1786912267.34224338.2
 
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.