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

224 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
radishes126946(None) 
ravishes1478041ravishes
banishes131812462banishes
brandishes1645892brandishes
danishes121710492danishes
dishes104622652__dishes
famishes1658282famishes
kaddishes1844092kaddishes
lavishes1457402lavishes
marishes13512552marishes
parishes13314752parishes
radiates92415292radiates
radices102314262radi_ces
radicles11249702radicles
radish103516912radish__
radiuses937042radiuses
radixes15259342radi_xes
raises64826542ra_is_es
rashes95330152ra__shes
ratfishes1546102ratfishes
ravished1555712ravished
ravisher1465462ravisher
ravishers1564782ravishers
redfishes1645792redfishes
relishes11311952relishes
vanishes141610752vanishes
abashes12510373_abashes
advisees12154133_advisees
advises11138973_advis_es
aisles64721143_a_isles
anises64826693_anis_es
arises65233803_aris_es
arrises71617583arris_es
artistes83213343artistes
ashes86230613_a__shes
axises134413993_axis_es
babiches1735253babiches
badasses1136173badasses
banished14189063banished
banisher13169183banisher
banishers14258053banishers
bashes115631393ba__shes
batfishes1746583batfishes
batistes1039713batistes
blandishes1644613blandishes
braises93818873bra_is_es
brandished1744003brandished
brashes124518463bra__shes
caddises12329353caddis_es
calashes13310533calashes
caliches153812263caliches
camises114218463camis_es
cashes114729883ca__shes
catfishes1746303catfishes
codfishes1845643codfishes
crashes124618403cra__shes
crawfishes2143593crawfishes
crayfishes2143403crayfishes
cuishes122810823_cuishes
daises74318983da_is_es
daisies84217093da_isies
dashes106124983__dashes
dished114318713__dished
dismes95617673__dismes
disses75225963__disses
emdashes14224303emdashes
endashes12217453endashes
enravishes1642153enravishes
eradiates102010783eradiates
evanishes1545603evanishes
famished1766023famished
faradises13248983faradis_es
fashes124524023fa__shes
fetishes1437153fetishes
finishes1438983finishes
fishes125221343__fishes
fraises104215693fra_is_es
galoshes1236893galoshes
gamashes1456943gamashes
garfishes16167083garfishes
garnishes13198813garnishes
gashes105725153ga__shes
gradines103615253gradi_nes
graduses1046453gradus_es
grayfishes2043633grayfishes
hadiths1436023hadith_s
hagfishes1945153hagfishes
hashes125024803ha__shes
hashishes1444393hashishes
headfishes2044413headfishes
iodises83413633iodis_es
jadish17319903jadish__
jadishly2243653jadishly
knishes1438263_knishes
ladies75124883ladi__es
ladyfishes2052843ladyfishes
lapises93513463lapis_es
lashes94831003la__shes
lavashes1445573lavashes
lavished1555133lavished
lavisher1445083lavisher
lavishers1564643lavishers
lavishest1554883lavishest
marshes123615373ma_rshes
mashes115030003ma__shes
mavises122812993mavis_es
minishes13310583minishes
modistes1138643modistes
monishes13311483monishes
mudfishes1844193mudfishes
oarfishes15156953oarfishes
padishah1742483padishah
padishahs1841663padishahs
panfishes1737593panfishes
paradises122513203paradis_es
parises94827183paris_es
pashes115828393pa__shes
pavises125315493pavis_es
pavisses13397103pavisses
perishes13313753perishes
pishes114722103__pishes
planishes14138523planishes
polishes13711783polishes
praises94121103pra_is_es
praxises1739063praxis_es
punishes1338113punishes
rabies85226023rabi__es
rachises131412413rachis_es
racisms112310813racis_ms
racists92613323racis_ts
raddles93615703rad_dles
radiale83813523radiale_
radials83614633radi_als
radiances1247693radiances
radians83013823radi_ans
radiants9259443radiants
radiate83416313radiate_
radiated102512593radiated
radicals112610153radicals
radicates12412073radicates
radicel10278873radi_cel
radicels11297183radicels
radicle103510713radicle_
radioed939673radi_oed
radiomen1146633radiomen
radios74018673radi__os
radiums10299313radi_ums
radius73914873radi__us
radomes10311053rad_omes
radwastes1364123radwastes
raise54828053ra_is_e_
raised76120333ra_is_ed
raiser66620103ra_is_er
raisers73617393ra_isers
raisins72715343ra_isins
rakish134313963rakish__
rakishly1844293rakishly
rakishness1744613rakishness
ramies84630463rami__es
ramifies13310503ramifies
ramilies10311833ramilies
ranches123620113ra_nches
randies84225663randi__es
raphes115117453ra__phes
rapines95120863rapi_nes
rapists92510753rapis_ts
rarifies11311933rarifies
rarities8316333rarities
rases55447213ra__s_es
rasher95024123ra__sher
rashers104020913ra__shers
rashest103916873ra__shest
rassles73513923ra_ssles
ratches123620463ra_tches
ratifies11313513ratifies
ratines75328583rati_nes
ratites74920683rati_tes
raunches1368053raunches
ravines104220233ravi_nes
ravish123414033ravish__
rawish123012913rawish__
readies83324713readi__es
realises82420183realis_es
rehashes1436953rehashes
relished1239433relished
remises93423483remis_es
rerises73525883reris_es
reshes94124363r__eshes
revises104220533revis_es
rewashes1447033rewashes
riches115022083r__iches
rikishas1542543rikishas
rises55244043r__is_es
rishis9312453r__ishis
roadies83317443roadi__es
roadsides1144463roadsides
rubbishes1644303rubbishes
rushes94724363r__ushes
sadhes104715373sad__hes
sadisms10359113sadis_ms
sadists83310853sadis_ts
sandfishes1745543sandfishes
sashes94728483sa__shes
sawfishes1845743sawfishes
squishes20198393squishes
standishes1445713standishes
swishes133411373_swishes
tamises92715973tamis_es
tapises92914013tapis_es
tarnishes12188893tarnishes
toadfishes1743793toadfishes
trashes104119263tra__shes
tundishes1344543tundishes
unwishes14147483unwishes
valises103516263valis_es
vanished15207743vanished
vanisher14167453vanisher
vanishers15186613vanishers
varnishes15207913varnishes
wadies105121203wadi__es
wampishes1944303wampishes
washes124425493wa__shes
whishes16309443_whishes
wishes124920953__wishes

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 Filter1786911461620.406440125.6
2DLD Change Limit1461622247.43619656.0
3Display Results2242240.0802800.0
 (SQL Overall)1786912247.92222556.3
 
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.