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

324 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
shandies12271411(None) 
shannies113411261shannies
shanties113116591shanties
shindies122610501shindies
bandies104124862_bandies
brandies11714562brandies
candies104125612_candies
chanties132615802chanties
dandies94121442_dandies
handier113817442_handier
handiest123417782_handiest
handles114020652_handles
hankies143617762_hankies
hardies114923232_hardies
pandies104224502_pandies
randies84225662_randies
sandier84017842s_andier
sandiest93218692s_andiest
sanies63031952s_an_ies
scandias1137862scandias
scanties103215422scanties
shades105924532sha_d_es
shadier113111152sha_dier
shadiest121711282sha_diest
shammies15259692shammies
shantihs14276212shantihs
shantis103313102shanti_s
sharpies13411232sharpies
shavies134213212sha_vies
shindigs13284202shindigs
shinnies113010912shinnies
shoddies1336052shoddies
standees93310142standees
baddies114017873_baddies
baldies105317703_baldies
bandied114414303_bandied
bandits103814793_bandits
banties94324763_banties
bawdies134613393_bawdies
beanies93821093bean_ies
brandied1259113brandied
caddies113718383_caddies
candids113812693_candids
candied113816023_candied
candles104422343_candles
challies133915643challies
chammies172910163chammies
chances145218093chan_ces
chancier1538823chancier
chanciest1638383chanciest
chancres15429363chancres
chandler14358373chandler
chandlers15387673chandlers
changes134517583chan_ges
chantries14310293chantries
chappies172610103chappies
charlies133414233charlies
crannies10313013crannies
cyanides14258003cyanides
daddies103414943_daddies
dandier93714573_dandier
dandiest103415033_dandiest
dandles94218533_dandles
fancies124018783_fancies
fannies103415643_fannies
gaudies9311973_gaudies
gharries12318213gharries
ghazies2036913gha_zies
glandes95413833gland_es
grandees103211283grandees
grannies9312613grannies
hackies163418243_hackies
hades96035113_ha_d_es
hadjes175210403_ha_djes
halides113416663_halides
hances115621283_han_ces
handaxes1938403_handaxes
handed114919983_hand_ed
hander104526433_hand_er
handers114224333_handers
handily143610873_handily
handiness132110933_handiness
handing123518893_handing
handle104219293_handle_
handled124114533_handled
handler113516163_handler
handlers124014143_handlers
handless123512063_handless
hands95327383_hand__s
handsel11308723_handsel
handsels12317253_handsels
handset113016823_handset
handsets12258343_handsets
hankie133915713_hankie_
hanses95022633_han_ses
hantles104117513_hantles
hardier114721543_hardier
hardiest123416343_hardiest
harpies123818323_harpies
harries103525493_harries
hawkies173311243_hawkies
henries102718283_henries
hinnies103615103_hinnies
hondles113614523_hondles
hongies112716473_hongies
honkies143015143_honkies
hoodies113419833_hoodies
howdies142911953_howdies
hunkies143214503_hunkies
hurdies114015663_hurdies
indies73822783__indies
khadis1446913kha_di_s
khanates1535733khanates
laddies93715053_laddies
ladies75124883_la_dies
lindies8416583_lindies
maundies1137853maundies
meanies93620743mean_ies
mishandles1643773mishandles
nancies93516843_nancies
nandins8312003_nandins
nannies73015203_nannies
organdies1187213organdies
paddies113715723_paddies
pandied113913443_pandied
pandits103914213_pandits
pansies94521983_pansies
panties94230933_panties
phonies123717513phon_ies
randier83618473_randier
randiest93418773_randiest
readies83324713rea_dies
rehandles1345593rehandles
roadies83317443roa_dies
saddles95415743s_addles
sades65239893s_a_d_es
sadhes104715373s_a_dhes
sadis64930853s_a_di_s
sallies73227813s_allies
salties73725773s_alties
sandals82715203s_andals
sanded84920613s_and_ed
sander74828533s_and_er
sanders84025943s_anders
sandflies1346513s_andflies
sandhis1139993s_andhis
sandiness102111713s_andiness
sanding93520603s_anding
sandless93212343s_andless
sandmen1039413s_andmen
sandpiles1246303s_andpiles
sandpits1146843s_andpits
sands65228583s_and__s
sanes55649073s_an__es
sanidines1048043s_anidines
sanities81219773s_anities
sanseis73011603s_anseis
santims9312603s_antims
santirs7312963s_antirs
sardines92815573s_ardines
sardius839553s_ardius
sassies74719263s_assies
sauries72821623s_auries
savvies1337603s_avvies
scabies11613333sca_bies
scampies1439333scampies
scandals1136993scandals
scandia1038063scandi_a
scandic1237003scandi_c
scandium1365693scandium
scandiums1443983scandiums
scantier10309983scantier
scantiest112611013scantiest
seances93015343sean_ces
seasides938743seasides
shabbier1535183shabbier
shabbiest1635333shabbiest
shackles173010593shackles
shackoes17367853shackoes
shade95125583sha_d_e_
shaded114518873sha_d_ed
shader104218763sha_d_er
shaders115915553sha_ders
shadflies1643833shadflies
shadily1437723sha_dily
shadiness1337463sha_diness
shading123115563sha_ding
shadings13327433sha_dings
shadows1437193sha_dows
shads95124483sha_d__s
shadufs1433673sha_dufs
shaggier13116053shaggier
shaggiest14156903shaggiest
shahdoms1743773shahdoms
shakes135024593sha__kes
shakier143411153sha_kier
shakiest151910943sha_kiest
shakoes144510023sha_koes
shales94731253sha__les
shalier103116423sha_lier
shaliest111415063sha_liest
shambles15159043shambles
shames114726223sha__mes
shammes144312833sha_mmes
shammied16265543shammied
shamois123210423shamoi_s
shamuses1336153shamuses
shanachies1844273shanachies
shandy134710033shand__y
shanked153212123shan_ked
shanking163612283shanking
shanks135315583shan__ks
shantey134210043shan_tey
shanteys14395513shanteys
shanti94014093shanti__
shantih13309643shanti_h
shapes115124953sha__pes
shards104319173shard__s
shares95236413sha__res
sharias102516003sha_rias
sharifs13279903sha_rifs
sharpie1238403sharpie_
shasliks1544143shasliks
shaves125224933sha__ves
shavie124312423sha_vie_
sheenies111411543sheenies
shelties111111383shelties
shending132511253shending
shends105313773shend__s
sherries111812893sherries
shies86136553sh___ies
shimmies15287803shimmies
shindig12244243shindi_g
shindys14314133shind_ys
shines95028913shin__es
shingles123111113shingles
shinier104113143shin_ier
shiniest113212503shin_iest
shinnied12345823shinnied
shoddier1334213shoddier
shoddiest1434763shoddiest
shorties11414583shorties
shrewdies1643743shrewdies
shunpikes1841903shunpikes
skankier11184883skankier
skankiest12145713skankiest
slander84015443sland_er
slanders94014013slanders
slangier9117933slangier
slangiest10129083slangiest
smarties10312873smarties
soddies92312853s_oddies
sondes74922873s_ond_es
sonnies7315223s_onnies
spades94222583spa_d_es
spadices1336093spa_dices
spadixes1834113spa_dixes
spandex1735833spand_ex
spandexes1943453spandexes
spandrel1144063spandrel
spandrels1243253spandrels
spandrils1244163spandrils
spangles1138893spangles
spaniel948923span_iel
spaniels1045963span_iels
spavies123012953spa_vies
spendier1147143spendier
spendiest1237533spendiest
spindles112710353spindles
spinnies103210543spinnies
spondees1136483spondees
spunkies14227593spunkies
staddles10258693staddles
stades74626243sta_d_es
stadias8411113sta_dias
staggies101210323staggies
stances93715963stan_ces
stanches132312793stanches
standbys1443203standbys
standee83514513stand_ee
stander84316163stand_er
standers93514303standers
standing103413633standing
standings11257153standings
standish1238543standish
standishes1445713standishes
standpipes1543073standpipes
stands75118053stand__s
standups1143963standups
stanes64933403stan__es
stanines85115673stanines
stannites947023stannites
steadies9311123steadies
studdies10207073studdies
studies82413863s_tudies
sturdies92110273sturdies
sundaes8313093s_undaes
sundries9312023s_undries
swabbies15115713swabbies
swaddles13296453swaddles
swaggies13136693swaggies
swamies123712063swa_mies
swankier15225503swankier
swankiest16136213swankiest
swindles12319503swindles
syndics1335703s_yndics
tansies74521243_tansies
tardies84225863_tardies
thanages12107623thanages
thanes94918983than__es
toadies82914863toa_dies
trannies8415013trannies
trendies9312213trendies
twankies1535893twankies
undies73821963__undies
unhandier1344883unhandier
unhandiest1444613unhandiest
uranides92211283uranides
waddies124214753_waddies
wadies105121203_wa_dies
whammies18265513whammies
whangees15275063whangees
whinnies14237273whinnies
zanies153219673_zan_ies

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 Filter1786911461620.436409841.7
2DLD Change Limit1461623247.53019410.6
3Display Results3243240.1402314.3
 (SQL Overall)1786913248.10622044.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.