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

265 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
shannies11341126(None) 
shandies122714111shandies
shanties113116591shanties
shinnies113010911shinnies
chanties132615802chanties
crannies10313012crannies
fannies103415642_fannies
grannies9312612grannies
hankies143617762_hankies
hinnies103615102_hinnies
nannies73015202_nannies
sanies63031952s_a_nies
scanties103215422scanties
shammies15259692shammies
shantihs14276212shantihs
shantis103313102shanti_s
sharpies13411232sharpies
shavies134213212sha_vies
sheenies111411542sheenies
shindies122610502shindies
shinnied12345822shinnied
sonnies7315222s_onnies
spinnies103210542spinnies
stanines85115672stanines
stannites947022stannites
trannies8415012trannies
whinnies14237272whinnies
alanines8314803alanines
bandies104124863_bandies
banties94324763_banties
beanies93821093bea_nies
bennies93917313_bennies
blennies1056933blennies
brandies11714563brandies
brannier10218933brannier
branniest11199383branniest
bunnies94415003_bunnies
candies104125613_candies
canines93724033_canines
cannie83819363_cannie_
cannier94014163_cannier
canniest10313363_canniest
carnies94123963_carnies
chaines124518733chain_es
challies133915643challies
chammies172910163chammies
chances145218093cha_nces
chancier1538823chancier
chanciest1638383chanciest
chancres15429363chancres
changes134517583cha_nges
channel123910483chann_el
channels13388493channels
chantries14310293chantries
chappies172610103chappies
charlies133414233charlies
crannied1137893crannied
cyanines132710543cyanines
dandies94121443_dandies
fancies124018783_fancies
funnies104113603_funnies
gharries12318203gharries
ghazies2036913gha_zies
grannie8310353grannie_
guanines989773guanines
gunnies83413123_gunnies
hackies163418243_hackies
hances115621283_ha_nces
handier113817443_handier
handiest123417783_handiest
handles114020653_handles
hankie133915713_hankie_
hanses95022633_ha_nses
hantles104117513_hantles
hardies114923233_hardies
harpies123818323_harpies
harries103525493_harries
hawkies173311243_hawkies
heinies102514543_heinies
henries102718283_henries
hinnied11348103_hinnied
hongies112716473_hongies
honkies143015143_honkies
hunkies143214503_hunkies
jennies143511623_jennies
joannes1436243joann_es
johannes1842943johann_es
johnnies1872993johnnies
khanates1535733khanates
mannites10312613_mannites
meanies93620743mea_nies
minnies93617363_minnies
nancies93516843_nancies
nannie63713223_nannie_
ninnies73713613_ninnies
pandies104224503_pandies
pannes85522853_pann_es
pannier93613353_pannier
panniers10488853_panniers
pansies94521983_pansies
panties94230933_panties
pennies94218813_pennies
phonies123717513ph_onies
pinnies93318443_pinnies
randies84225663_randies
rhatanies1244983rhatanies
sabines94318483s_abines
salines74029413s_alines
sallies73227813s_allies
salties73725773s_alties
sandier84017843s_andier
sandiest93218693s_andiest
sanes55649073s_a_n_es
sanities81219773s_anities
sannops936693s_annops
sannups934463s_annups
sanseis73011603s_anseis
santims9312603s_antims
santirs7312963s_antirs
sassies74719263s_assies
sauries72821623s_auries
savines104417633s_avines
savvies1337603s_avvies
saxonies1537913saxonies
scabies11613333sca_bies
scampies1439333scampies
scandias1137863scandias
scanned104110893scann_ed
scanner94411813scann_er
scanners10379703scanners
scanning113310773scanning
scannings12264823scannings
scantier10309983scantier
scantiest112611013scantiest
seances93015343sea_nces
sennits73811283s_ennits
shabbier1535183shabbier
shabbiest1635333shabbiest
shackles173010593shackles
shackoes17367853shackoes
shades105924533sha__des
shadflies1643833shadflies
shadier113111153sha_dier
shadiest121711283sha_diest
shadiness1337463shadiness
shadings13327433shadings
shaggier13116053shaggier
shaggiest14156903shaggiest
shakes135024593sha__kes
shakier143411153sha_kier
shakiest151910943sha_kiest
shakiness1637083shakiness
shakoes144510023sha_koes
shales94731253sha__les
shalier103116423sha_lier
shaliest111415063sha_liest
shambles15159043shambles
shames114726223sha__mes
shammes144312833sha_mmes
shammied16265543shammied
shamois123210423shamoi_s
shamuses1336153shamuses
shanachies1844273shanachies
shanked153212123sha_nked
shanking163612283shanking
shanks135315583sha_n_ks
shanny124110093shann__y
shantey134210043sha_ntey
shanteys14395513shanteys
shanti94014093shanti__
shantih13309643shanti_h
shapes115124953sha__pes
shares95236413sha__res
sharias102516003sha_rias
sharifs13279903sha_rifs
sharns95516983sharn__s
sharpie1238403sharpie_
shasliks1544143shasliks
shaves125224933sha__ves
shavie124312423sha_vie_
shavings15356333shavings
sheenie10159493sheenie_
sheenier11167423sheenier
sheeniest12158363sheeniest
shelties111111383shelties
sherries111812893sherries
shies86136553sh___ies
shimmies15287803shimmies
shindigs13284203shindigs
shines95028913sh_in_es
shingles123111113shingles
shinier104113143sh_inier
shiniest113212503sh_iniest
shininess1237333shininess
shinned114310913shinn_ed
shinneries1345713shinneries
shinney13368293shinn_ey
shinneys14275093shinneys
shinning123211023shinning
shoddies1336053shoddies
shorties11414583shorties
shrines104618693shrin_es
shunned11417843shunn_ed
shunner10358643shunn_er
shunners11317743shunners
shunning12367843shunning
shunpikes1841903shunpikes
simonies10311113simonies
skankier11184883skankier
skankiest12145713skankiest
skinnier1264893skinnier
skinniest1335523skinniest
slangier9117933slangier
slangiest10129083slangiest
smarties10312873smarties
solanines9310083solanines
sonances10310263sonances
spangles1138893spangles
spaniel948923spa_niel
spaniels1045963spa_niels
spanned104111223spann_ed
spanner94312563spann_er
spanners103710773spanners
spanning113311083spanning
spavies123012953spa_vies
spoonies101911753spoonies
spunkies14227593spunkies
squinnies1844483squinnies
staggies101210323staggies
stances93715963sta_nces
stanches132312793stanches
standees93310143standees
stanes64933403sta_n_es
stanine73417073stanine_
stannaries1045783stannaries
stannic936663stanni_c
stannite847583stannite
stannous846443stannous
stannums1043803stannums
sunnier73412153s_unnier
sunniest82712913s_unniest
swabbies15115713swabbies
swaggies13136693swaggies
swamies123712063swa_mies
swankier15225503swankier
swankiest16136213swankiest
swanned11358173swann_ed
swanneries1344363swanneries
swanning12338813swanning
sweenies11148763sweenies
tannins72813223_tannins
tansies74521243_tansies
tawnies102812503_tawnies
tennies73017973_tennies
thanages12107623thanages
thanes94918983tha_n_es
tunnies73614263_tunnies
twankies1535893twankies
tyrannies1255533tyrannies
whammies18265513whammies
whangees15275063whangees
whinnied15284153whinnied
whinnier14255003whinnier
whinniest15245133whinniest
zanies153219673_za_nies

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 Limit1461622657.12620511.1
3Display Results2652650.1401892.9
 (SQL Overall)1786912657.67223291.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.