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

210 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
shanteys1439551(None) 
chanteys16387491chanteys
shantey134210041shantey_
chanters134016742chanters
chantey154112542chantey_
shanties113116592shanties
shantihs14276212shantihs
shantis103313102shant_is
shanty124715122shant_y_
shatters113313912shatters
shinneys14275092shinneys
shunters113210752shunters
antes56334323__ante_s
banters94623113_banters
canters94827733_canters
chancels15439083chancels
chancers154313493chancers
chances145218093chance_s
changers144313203changers
changes134517583change_s
channels13388493channels
chanted134015953chante_d
chanter123919733chante_r
chanteuse1443473chanteuse
chanties132615803chanties
chantors133710263chantors
chantry15388223chantry_
chants115020393chant__s
chanty145215823chant_y_
chapters154012133chapters
charleys1695633charleys
charters134115583charters
chastens13429183chastens
chattels13286793chattels
chatters134213953chatters
chaunters1455823chaunters
chunters133910903chunters
chutneys1642323chutneys
giantess933893giantess
grantees92510973grantees
granters93614143granters
hafters134614333_hafters
halters104619803_halters
hances115621283_hance_s
handers114224333_handers
hangers113120813_hangers
hankers144218133_hankers
hansels104011663_hansels
hanses95022633_hanse_s
hanted104124313_hante_d
hantles104117513_hantles
hants86335403_hant__s
haptens124511343_haptens
hastens106214813_hastens
hastes95727073_haste_s
haters94930403_ha_ters
hates86742573_ha_te_s
hatters104221523_hatters
haunters11329543_haunters
hawkeys20414703_hawkeys
henleys1334843_henleys
hinters103719583_hinters
honeys124016083_hon_eys
honkeys17439513_honkeys
hunkeys17386193_hunkeys
hunters103915733_hunters
khanates1535733khanate_s
mantels94515043_mantels
mantes84430783_mante_s
mateys115610943_ma_teys
mishanters1544983mishanters
phantasy1643463phantasy
phantoms1545973phantoms
phoneys15437143phon_eys
planters102915323planters
ranters73323643_ranters
salters73622253s_alters
sanders84025943s_anders
sanes55649073s_an_e_s
sangers84421943s_angers
sanies63031953s_anie_s
sanseis73011603s_anseis
santera7311303s_antera
santeras8311063s_anteras
santero7311133s_antero
santeros8311193s_anteros
santims9312603s_antims
santirs7312963s_antirs
santols73513323s_antols
santos64421833s_ant_os
santurs7310763s_anturs
satays94411683s_a_tays
sates54949323s_a_te_s
saunters82911753saunters
sautes63924913s_aute_s
sawneys13274643s_awneys
scanners10379703scanners
scanted104114393scante_d
scanter94215183scante_r
scantest101710183scantest
scanties103215423scanties
scantly12419553scantly_
scantness1135733scantness
scants85219723scant__s
scanty114014663scant_y_
scatters103612753scatters
seances93015343seance_s
seaters74028943sea_ters
senates73322613senate_s
shaders115915553sha_ders
shades105924533sha_de_s
shafted14288813shafte_d
shafts125411443shaft__s
shaitans1136413shaitans
shakers144015563sha_kers
shakes135024593sha_ke_s
shakoes144510023shakoe_s
shales94731253sha_le_s
shaley123714993sha_ley_
shames114726223sha_me_s
shammers153710843shammers
shammes144312833shamme_s
shamoys15367283sha_moys
shandies122714113shandies
shandy134710033shan_dy_
shanked153212123shanke_d
shanks135315583shan__ks
shannies113411263shannies
shanny124110093shan_ny_
shanti94014093shant__i
shantih13309643shant_ih
shantung1232743shantung
shantungs1341653shantungs
shapers124016893sha_pers
shapes115124953sha_pe_s
sharers104720623sha_rers
shares95236413sha_re_s
sharkers154011053sharkers
sharpens13377813sharpens
sharpers133810943sharpers
shatter103615703shatte_r
shavers134115093sha_vers
shaves125224933sha_ve_s
shavies134213213shavie_s
shays116021433sha___ys
sheeneys14294903sheeneys
sheeters113111863sheeters
shelters113412813shelters
shifters14319863shifters
shindys14314133shin_dys
shiners104015943shin_ers
shines95028913shin_e_s
shinney13368293shinney_
shooters112811583shooters
shortens11288993shortens
shotes95321913sh_ote_s
shouters113510623shouters
shtetels1143233shtetels
shunners11317743shunners
shunted11339783shunte_d
shunter103611733shunte_r
shunts95712023shunt__s
shutes93518223sh_ute_s
shuteye1343363sh_uteye
shuteyes1443473sh_uteyes
shutters113611353shutters
shyness1344993shyn_ess
shysters14106463shysters
sinters74024083s_inters
skankers11316483skankers
skaters113512963ska_ters
skates104219403ska_te_s
slanders94014013slanders
slanted83514743slante_d
slantly10399323slantly_
slants64819083slant__s
slantways1542113slantways
slanty95114843slant_y_
slaters73123733sla_ters
slates64934063sla_te_s
slatey95417063sla_tey_
slaveys13415203sla_veys
smartens10286663smartens
smatters104011713smatters
spancels1245273spancels
spaniels1045963spaniels
spankers14369863spankers
spanless10247363spanless
spanners103710773spanners
spates85028173spa_te_s
spatters103914703spatters
spinneys13335553spinneys
stactes91914633stacte_s
stances93715963stance_s
standbys1443203standbys
standees93310143standees
standers93514303standers
stanes64933403stan_e_s
starters83714773starters
staters73922343sta_ters
states64337083sta_te_s
stinters83312753stinters
swatters113911793swatters
swinneys14264203swinneys
thanes94918983than_e_s
thankers15297833thankers
wanters104420093_wanters
whangees15275063whangees
whatness1435093whatness
whiteys16396153wh_iteys

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 Limit1461622107.28320068.9
3Display Results2102100.0932258.1
 (SQL Overall)1786912107.78222962.1
 
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.