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

215 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
toadish113906(None) 
toadfish1544901toadfish
toadyish1544151toadyish
boarish123911912boarish
broadish1446932broadish
coldish1399302coldish
goatish1139562goatish
goodish1237962goodish
jadish17319902_jadish
loudish1137982loudish
modish123813542mo_dish
oafish121311722_oafish
oddish11107652_oddish
oldish10169312_oldish
radish103516912_radish
toadied9248012toadied
toadies82914862toadies
toads65621072toad_s_
toadyism1443672toadyism
tonish93415902to_nish
tonnish10149092tonnish
tovarish1445122tovarish
townish13167932townish
toyish122911122to_yish
tsadis7429132tsadis_
tundish1137282tundish
apish105116633__apish
baldish1339503baldish
banish111416053_banish
beamish14259293beamish
bearish123013273bearish
beauish12268513beauish
blandish1497003blandish
blondish1476173blondish
boarfish1635753boarfish
boggish14238653boggish
boobish14338943boobish
bookish163610023bookish
boorish123712593boorish
boxfish2285543boxfish
boyish142911233bo_yish
brandish1469023brandish
caddish143810133caddish
cadis84428503_cadis_
cladism1238553cladism
cladist10311973cladist
clayish1547943clayish
cloddish1544233cloddish
coalfish1635493coalfish
coatis85122603coatis_
cockish1838503cockish
codfish1637163codfish
coltish121310933coltish
coolish12312523coolish
cowfish1836433cowfish
coyish143710393co_yish
danish101513803_danish
deafish1438533deafish
dish86328333___dish
dogfish15226763dogfish
doggish13237533doggish
dollish11610093dollish
doltish11118733doltish
donnish11187633donnish
dovish1338103do_vish
dowdyish1952833dowdyish
dudish1148313_dudish
evanish1337663evanish
faddish15359003faddish
famish14311843_famish
fogyish1735363fogyish
folkish1736563folkish
foolish1339613foolish
foppish1735103foppish
foxfish2354483foxfish
gadis74825293_gadis_
garish104516923_garish
goading103112853goading
goads77022853goad_s_
goatfish1544293goatfish
goldfish1644203goldfish
goyish13379013go_yish
grayish1437813grayish
hadith13312063_hadith
headfish1845443headfish
hogfish17257023hogfish
hoggish15247593hoggish
hottish13117903hottish
iodise74214943io_dise
iodism93611133io_dism
kaddish16317973kaddish
kadis105921063_kadis_
khadis1446913khadis_
kiddish16276583kiddish
knavish1743993knavish
laddish12299723laddish
ladyish14287823_ladyish
latish92416173_latish
lavish124112983_lavish
loading94114613loading
loads65323373load_s_
loggish12258733loggish
longish11229093longish
loutish1039963loutish
lowish12310533lo_wish
maddish14289483maddish
maidish13239553maidish
marish114319053_marish
mobbish1635923mobbish
monadism1348023monadism
monish114217593mo_nish
monkish1638243monkish
moonish123311043moonish
moorish123311783moorish
mopish134311593mo_pish
nerdish1137103nerdish
noirish1037883noirish
nomadism1346403nomadism
nourish1039703nourish
oarfish13158613_oarfish
oasis56422553_oasis_
odist6421913_o_dist
offish15137273_offish
ogrish1039263_ogrish
owlish1238703_owlish
padis86227143_padis_
palish114718273_palish
parish115022353_parish
peakish16268873peakish
planish12412053planish
polish114916723po_lish
poorish123712303poorish
popish133812113po_pish
prudish1376563prudish
qadis155917853_qadis_
rakish134313963_rakish
ravish123414033_ravish
rawish123012913_rawish
reddish1238033reddish
roadie72813813roadi_e
roadies83317443roadies
roads66523623road_s_
roguish1156833roguish
rompish1436693rompish
roundish1246253roundish
rowdyish1852663rowdyish
sadis64930853_sadis_
sadism94113493_sadism
sadist74221353_sadist
slavish1338233slavish
softish13127813softish
sottish10129443sottish
sourish10310693sourish
standish1238543standish
stockish17186043stockish
stonish10410653sto_nish
stoutish1145903stoutish
tads57143943t_ad_s_
tallish103313583tallish
tamis76728733t_amis_
tanist6324603t_anist
tannish101610573tannish
tapis75028863t_apis_
tarnish101611873tarnish
tartish101512633tartish
taxis126821973t_axis_
tigrish1137573tigrish
toad55830183toad___
toadfishes1743793toadfishes
toadless936313toadless
toadlike1336143toadlike
toady96814343toad__y
toadying1335043toadying
toadyisms1542943toadyisms
toast55831013toa__st
toasts65914993toasts_
todays10458103todays_
toddies93011993toddies
todies74223553to_dies
tods56141843to_d_s_
tondi65716143tondi__
tondos75115923tondos_
topis76025833to_pis_
tosh74826813to___sh
totalise8312503totalise
totalism10311093totalism
totalist8315583totalist
toughish1545283toughish
tourism939423tourism
tourist7313203tourist
tovarich1643453tovarich
trades75724503trades_
trading93517973trading
trampish1535653trampish
trash86119763tra__sh
triadism1147553triadism
tsades74310993tsades_
tsadi6379913tsadi__
tsarism958253tsarism
tsarist7712253tsarist
tuladis835703tuladis_
tzarism1866323tzarism
tzarist1659103tzarist
vanish121513223_vanish
voguish1465203voguish
wadis95223963_wadis_
weakish17217173weakish
wearish132310153wearish
widish13419363_widish
wildish1446853wildish
woads94818443woad_s_
woggish15276673woggish
wolfish1636933wolfish
womanish1646823womanish
wormish1537163wormish

Search took 9 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 Limit1340272158.00016753.4
3Display Results2152150.0802687.5
 (SQL Overall)1786912158.50021022.5
 
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.