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

405 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
chantey15411254(None) 
chanted134015951chanted
chanter123919731chanter
chanteys16387491chanteys
chantry15388221chantry
chanty145215821chant_y
shantey134210041shantey
canted94825782c_anted
canter85230112c_anter
canty105226802c_ant_y
chance134617092chance_
chanced154113212chanced
chancel144011782chancel
chancer144215632chancer
chancery18366652chancery
chances145218092chances
chancy164010862chan_cy
change124116752change_
changed144214142changed
changer134215542changer
changes134517582changes
channel123910492channel
chant105932692chant__
chanters134016742chanters
chanties132615802chanties
chantor123710312chantor
chants115020392chant_s
chapter144213852chapter
charley15118272charley
charted135116852charted
charter123918302charter
chaste114617392chaste_
chastely1635812chastely
chasten124312402chasten
chaster124718502chaster
chatted133411892chatted
chattel12388892chattel
chatter124416642chatter
chattery16357272chattery
chatty14419362cha_tty
chaunted1485602chaunted
chaunter1366392chaunter
chintzy24364222chintzy
chunter123911482chunter
chutney1533822chutney
hanted104124312_hanted
shanteys14395512shanteys
shanty124715122shant_y
ante46538903__ante_
anted66328243__anted
antes56334323__antes
antsy85712793__antsy
banter84825343_banter
banty106624003_bant_y
cagey115917823c_a_gey
cakey145517273c_a_key
canary11314693c_anary
cancel105316683c_ancel
cancer104220923c_ancer
candy115119823c_an_dy
cane66653123c_an_e_
caned85838093c_an_ed
caner75334773c_an_er
canes75350373c_an_es
canker124422523c_anker
canned95022063c_anned
cannel84216403c_annel
canner84625983c_anner
cannery123610013c_annery
canny105817693c_an_ny
canoe75627253c_anoe_
canoed94618963c_anoed
canoer85121073c_anoer
canoes84725883c_anoes
canopy1337733c_anopy
cant66362033c_ant__
cantal84122033c_antal
canteen9411083c_anteen
canters94827733c_anters
canthi11310973c_anthi
cantic103920543c_antic
cantle84522153c_antle
cantles94721413c_antles
canto74931013c_ant_o
canton85722993c_anton
cantor85621523c_antor
cantos84826973c_antos
cants77036943c_ant_s
cantus85117763c_antus
carney115315703c_arney
carte75940423c_arte_
carted98631443c_arted
cartel85022533c_artel
carter84932273c_arter
cartes86239473c_artes
caste75932363c_aste_
caster85232573c_aster
castes85631863c_astes
cate66254603c_a_te_
cater74840723c_a_ter
cates75951893c_a_tes
catted95422473c_atted
cattery123811603c_attery
catty104520413c_a_tty
causey113513273c_ausey
cautery12349593c_autery
center84421413c_enter
chaeta11310683chaet_a
chaetae1238603chaetae
chaetal1238283chaetal
chafe135117353cha_fe_
chafed154813913cha_fed
chafer144714573cha_fer
chafes145017913cha_fes
chaffed19387703chaffed
chaffer18389473chaffer
chaffy20456473cha_ffy
chaine115119223chaine_
chained133812693chained
chaines124518733chaines
chainmen15105263chainmen
chaired134211243chaired
chaise114916413chaise_
chaises124317493chaises
chaleh143711993cha_leh
chalet113825993cha_let
chalets122813473chalets
chalked17449863chalked
chalky18468773cha_lky
chally144314293cha_lly
chamber164011063chamber
chamfer17399863chamfer
chammy18488953cha_mmy
champed174111483champed
champer163813413champer
champy18509613cha_mpy
chancels15439093chancels
chancers154313493chancers
chancier1538823chancier
chancily1845243chancily
chancre14348783chancre
chancres15429363chancres
chandler14358373chandler
chandlery18384423chandlery
chang115418563chan__g
changers144313203changers
changeup1642683changeup
changs125215373chan_gs
channels13388503channels
chanoyu1544483chanoyu
chanson1238043chanson
chantage1446633chantage
chantages1546583chantages
chanteuse1443473chanteuse
chanting143413533chanting
chantors133710263chantors
chantries14310293chantries
chaoses124715123chaoses
chaotic14310043chaotic
chape125221143cha_pe_
chapel134911373cha_pel
chapes135421873cha_pes
chapiter1536603chapiter
chaplet14512253chaplet
chapmen1637283chapmen
chapped172711443chapped
chapt125827643chapt__
chapters154012133chapters
chare105231983cha_re_
chared125423693cha_red
chares115631803cha_res
charge125114213charge_
charged144614023charged
charger133914063charger
charges134615983charges
charier124317903charier
charily15310283charily
charity15311023charity
charked174814013charked
charleys1695633charleys
charmed154714253charmed
charmer144913663charmer
charnel124010053charnel
charpoy1735713charpoy
charred134614493charred
charry145012113cha_rry
chart105038283chart__
charters134115583charters
charts115823093chart_s
chary135023133cha__ry
chase105127123cha_se_
chased125019293cha_sed
chaser114918383cha_ser
chases115128233cha_ses
chasmed154710173chasmed
chasmy16468543cha_smy
chasse115114603chasse_
chassed134712133chassed
chasses124017503chasses
chastens13429183chastens
chastest1349703chastest
chastity1645273chastity
chat95546133cha_t__
chateau1236273cha_teau
chats105730093cha_t_s
chattels13286793chattels
chatters134213953chatters
chattier1337513chattier
chattily1634603chattily
chaufer15347943chaufer
chaunt11613493chaunt__
chaunters1455823chaunters
chaunts1267083chaunt_s
chawed155214603cha_wed
chawer144314413cha_wer
chay124924873cha___y
chayote1536493chayote_
chayotes1636503chayotes
chazzen20214783chazzen
cheated134416343cheated
cheater124816963cheater
cherty144612473chert_y
chested133811673chested
chesty144610503chest_y
chianti1236613chiant_i
chiantis1346593chiantis
chimley1785163chimley
chimney1795483chimney
chinchy20335523chinchy
chine105231723chin_e_
chined125620063chin_ed
chines115029173chin_es
chinked174011023chinked
chinky185610543chin_ky
chinned134810503chinned
chints115117833chint_s
chintses1337113chintses
chintz204212033chint_z
chintzes2235973chintzes
chitter124112963chitter
chitty14329433ch_itty
choanae1236863choanae_
chokey184811713ch_okey
choosey15459233choosey
chorten122811303chorten
chunked17428213chunked
chunky18468273chun_ky
chunnel12395313chunnel
chunters133910903chunters
chute104316463ch_ute_
chuted124611843ch_uted
chutes114615773ch_utes
chutnee1246833chutnee
chutneys1642323chutneys
clanged114212653clanged
clanger104113493clanger
clanked143812253clanked
clanky15469073clan_ky
clatter94014973clatter
clattery13378193clattery
clayey14407663cla_yey
coacted123611613coacted
coannex1635513coannex
coapted123911503coapted
coasted104015963coasted
coaster94219043coaster
coated94927043coa_ted
coatee84327223coa_tee
coater84329573coa_ter
cointer93616723cointer
coney105932883c_on_ey
conte76633203c_onte_
contes84432913c_ontes
convey144610223c_onvey
counted103815803counted
counter94220153counter
country12388043country
county114313323count_y
crafted13419773crafted
crafter124111333crafter
crafty14478913craft_y
crane75331603cran_e_
craned96121653cran_ed
cranes84330753cran_es
cranked143812843cranked
cranker133612793cranker
crankly16358123crankly
cranky153910633cran_ky
cranny114210273cran_ny
crate76537403cra_te_
crated94827773cra_ted
crater85026643cra_ter
crates85736063cra_tes
cutey105819793c__utey
cyanate12259703cyanate_
cyanates13238433cyanates
cyanite122710763cyanite_
cyanites132610163cyanites
enchanted1546553enchanted
enchanter1446193enchanter
gantry103810113_gantry
ghastly14354563ghastly
granted94715103granted
grantee83217133grantee
granter84117133granter
hafted134713833_hafted
hafter124815883_hafter
halted105019603_halted
halter94420883_halter
hance105424153_hance_
hances115621283_hances
handed114919983_handed
hander104526433_hander
handy125520873_han_dy
hanged114222403_hanged
hanger104023263_hanger
hanked144220603_hanked
hanker134622093_hanker
hanky155418293_han_ky
hanse85722793_hanse_
hansel95214373_hansel
hanses95022633_hanses
hant75461593_hant__
hantle94318203_hantle
hantles104117513_hantles
hants86335403_hant_s
hapten115312983_hapten
haste85927863_haste_
hasted105125283_hasted
hasten95718563_hasten
hastes95727073_hastes
hasty115718763_hast_y
hate78450173_ha_te_
hated95734023_ha_ted
hater85034753_ha_ter
hates86742573_ha_tes
hatted104921513_hatted
hatter94724873_hatter
haunted11399733_haunted
haunter103111153_haunter
haute89521613_haute_
hawkey19507633_hawkey
hayey144812533_ha_yey
henley1237483_henley
hented104218753_hented
hinted104318323_hinted
hinter94021303_hinter
honey115629913_hon_ey
honkey165113823_honkey
hunkey164210883_hunkey
hunted104417013_hunted
hunter94817773_hunter
janty156816963_jant_y
khanate1437073khanate_
khanates1535733khanates
mangey123614533_mangey
mantel84317973_mantel
mantes84430783_mantes
matey107022663_ma_tey
orangey11388833orangey
panted95024823_panted
pantry115014103_pantry
panty105929303_pant_y
phantasy1643463phantasy
phantom1436693phantom
phatter123810203phatter
phoney143612983phon_ey
planted103516123planted
planter94017803planter
quanted1738963quanted
ranted74324703_ranted
ranter63826823_ranter
riantly1037613riantly
scanted104114393scanted
scanter94215183scanter
scantly12419553scantly
scanty114014663scant_y
shafted14288813shafted
shaley123714993sha_ley
shandy134710033shan_dy
shanked153212123shanked
shanny124110093shan_ny
shanti94014093shant_i
shanties113116593shanties
shantih13309643shantih
shantis103313103shantis
shatter103615703shatter
shinney13368303shinney
shunted11339783shunted
shunter103611733shunter
slanted83514743slanted
slantly10399323slantly
slanty95114843slant_y
slatey95417063sla_tey
thane86122533than_e_
thanes94918983than_es
thanked15469153thanked
thanker14309593thanker
waney115120323_wan_ey
wanted104319723_wanted
wanter94423053_wanter
whanged15447613whanged
whangee14268623whangee
whiney155012643whin_ey
whitey154911883wh_itey

Search took 7 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.406440125.6
2DLD Change Limit1340274056.23621492.5
3Display Results4054050.1402892.9
 (SQL Overall)1786914056.78226347.8
 
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.