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

226 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
chanteys1638749(None) 
chanters134016741chanters
chantey154112541chantey_
shanteys14395511shanteys
canters94827732c_anters
chancels15439082chancels
chancers154313492chancers
chances145218092chance_s
changers144313202changers
changes134517582change_s
channels13388492channels
chanted134015952chante_d
chanter123919732chante_r
chanteuse1443472chanteuse
chanties132615802chanties
chantors133710262chantors
chantry15388222chantry_
chants115020392chant__s
chanty145215822chant_y_
chapters154012132chapters
charleys1695632charleys
charters134115582charters
chastens13429182chastens
chattels13286792chattels
chatters134213952chatters
chaunters1455822chaunters
chunters133910902chunters
chutneys1642322chutneys
shantey134210042shantey_
antes56334323__ante_s
banters94623113_banters
cancels114113313c_ancels
cancers114018583c_ancers
caners84629203c_an_ers
canes75350373c_an_e_s
cankers134418753c_ankers
cannels93413363c_annels
canners93822663c_anners
canoers94318373c_anoers
canoes84725883c_anoe_s
cantals93919573c_antals
canted94825783c_ante_d
canteen9411083c_anteen
canteens1038573c_anteens
canter85230113c_ante_r
canthus1248713c_anthus
cantles94721413c_antles
cantons95221203c_antons
cantors94620753c_antors
cantos84826973c_ant_os
cants77036943c_ant__s
cantus85117763c_ant_us
canty105226803c_ant_y_
carneys124310543c_arneys
cartels94618123c_artels
carters95327253c_arters
cartes86239473c_arte_s
casters94729903c_asters
castes85631863c_aste_s
caters85336503c_a_ters
cates75951893c_a_te_s
causeys12387223c_auseys
centers94420603c_enters
chadless1436403chadless
chafers154512743cha_fers
chafes145017913cha_fe_s
chaffers19378003chaffers
chaines124518733chaine_s
chaises124317493chaise_s
chalehs15268803cha_lehs
chalets122813473cha_lets
chambers173410623chambers
chamfers18409223chamfers
champers173311623champers
chance134617093chance__
chanced154113213chance_d
chancel144011773chance_l
chancer144215633chance_r
chancery18366653chancery
chancres15429363chancres
chancy164010863chan_cy_
chandlers15387673chandlers
change124116753change__
changed144214143change_d
changer134215543change_r
changeup1642683changeup
changeups1742183changeups
changs125215373chan__gs
channel123910483channe_l
chanoyu1544483chan_oyu
chanoyus1643923chanoyus
chansons1337473chansons
chant105932693chant___
chantage1446633chantage
chantages1546583chantages
chanteuses1543803chanteuses
chanting143413533chanting
chantor123710313chant_or
chantries14310293chantries
chaoses124715123chaose_s
chapels14429153cha_pels
chapes135421873cha_pe_s
chapiters1635203chapiters
chaplets1556883chaplets
chapter144213853chapte_r
chares115631803cha_re_s
chargers144011323chargers
charges134615983charge_s
charley15118273charley_
charmers154211333charmers
charnels13328173charnels
charpoys1834533charpoys
charted135116853charte_d
charter123918303charte_r
chartless1435703chartless
charts115823093chart__s
chasers123714923cha_sers
chases115128233cha_se_s
chasses124017503chasse_s
chaste114617393chaste__
chastely1635813chastely
chasten124312403chaste_n
chaster124718503chaste_r
chastest1349703chastest
chateau1236273cha_teau
chateaus1346013cha_teaus
chats105730093cha_t__s
chatted133411893chatte_d
chattel12388893chatte_l
chatter124416643chatte_r
chattery16357273chattery
chatty14419363cha_tty_
chaufers16347303chaufers
chaunted1485603chaunte_d
chaunter1366393chaunte_r
chaunts1267083chaunt__s
chawers154412053cha_wers
chayotes1636503chayote_s
chays135319743cha___ys
chazzens21253943chazzens
cheaters133613513cheaters
chiantis1346593chiant_is
chimleys1883633chimleys
chimneys1883643chimneys
chines115029173chin_e_s
chinless1337493chinless
chints115117833chint__s
chintses1337113chintses
chintzes2235973chintzes
chintzy24364223chintzy_
chitters133711173chitters
chortens13308793chortens
chunnels13304553chunnels
chunter123911483chunte_r
chutes114615773ch_ute_s
chutnees1343963chutnees
chutney1533823chutney_
clangers114312343clangers
clatters103313913clatters
coasters104317333coasters
coatees93816553coa_tees
coaters93525793coa_ters
cointers103616413cointers
coneys115218423c_on_eys
contes84432913c_onte_s
conveys15308223c_onveys
counters103320193counters
countess103710053countess
crafters13419953crafters
cranes84330753cran_e_s
craters95021893cra_ters
crates85736063cra_te_s
cuteys11569983c__uteys
cyanates13238433cyanate_s
cyanites132610163cyanite_s
enchanters1545223enchanters
giantess933893giantess
grantees92510973grantees
granters93614143granters
hafters134614333_hafters
halters104619803_halters
hances115621283_hance_s
handers114224333_handers
hangers113120813_hangers
hankers144218133_hankers
hansels104011653_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
phantasy1643463phantasy
phantoms1545973phantoms
phoneys15437143phon_eys
planters102915323planters
ranters73323643_ranters
shanties113116593shanties
shantihs14276213shantihs
shantis103313103shant_is
shanty124715123shant_y_
shatters113313913shatters
shinneys14275093shinneys
shunters113210753shunters
thanes94918983than_e_s
thankers15297833thankers
wanters104420093_wanters
whangees15275063whangees
whatness1435093whatness
whiteys16396153wh_iteys

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 Limit1461622267.87618557.9
3Display Results2262260.0932430.1
 (SQL Overall)1786912268.40521260.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.