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 “chanted” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

103 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
chanted13401595(None) 
canted94825781c_anted
chanced154113211chanced
changed144214141changed
chanter123919731chanter
chantey154112541chantey
charted135116851charted
chatted133411891chatted
chaunted1485601chaunted
hanted104124311_hanted
anted66328242__anted
caned85838092c_an_ed
canned95022062c_anned
canoed94618962c_anoed
canter85230112c_anter
carted98631442c_arted
catted95422472c_atted
chafed154813912cha_fed
chaffed19387702chaffed
chained133812692chained
chaired134211242chaired
chalked17449862chalked
champed174111482champed
chance134617092chance_
chancel144011772chancel
chancer144215632chancer
chances145218092chances
change124116752change_
changer134215542changer
changes134517582changes
channel123910482channel
chant105932692chant__
chanters134016742chanters
chanteys16387492chanteys
chanties132615802chanties
chantor123710312chantor
chantry15388222chantry
chants115020392chant_s
chanty145215822chant_y
chapped172711442chapped
chapter144213852chapter
chared125423692cha_red
charged144614022charged
charked174814012charked
charmed154714252charmed
charred134614482charred
charter123918302charter
chased125019292cha_sed
chasmed154710172chasmed
chassed134712132chassed
chaste114617392chaste_
chasten124312402chasten
chaster124718502chaster
chattel12388892chattel
chatter124416642chatter
chaunter1366392chaunter
chawed155214602cha_wed
cheated134416342cheated
chested133811672chested
chined125620062chin_ed
chinked174011022chinked
chinned134810492chinned
chunked17428212chunked
chunter123911482chunter
chuted124611842ch_uted
clanged114212652clanged
clanked143812252clanked
coacted123611612coacted
coapted123911502coapted
coasted104015952coasted
coated94927042coa_ted
counted103815802counted
crafted13419772crafted
craned96121652cran_ed
cranked143812842cranked
crated94827772cra_ted
enchanted1546552enchanted
granted94715102granted
hafted134713832_hafted
halted105019602_halted
handed114919982_handed
hanged114222392_hanged
hanked144220602_hanked
hasted105125282_hasted
hated95734022_ha_ted
hatted104921512_hatted
haunted11399732_haunted
hented104218752_hented
hinted104318322_hinted
hunted104417012_hunted
panted95024822_panted
planted103516122planted
quanted1738962quanted
ranted74324702_ranted
scanted104114392scanted
shafted14288812shafted
shanked153212122shanked
shantey134210042shantey
shunted11339782shunted
slanted83514742slanted
thanked15469152thanked
wanted104319722_wanted
whanged15447612whanged

Search took 4 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 Filter1786911076710.390458182.1
2DLD Change Limit1076711033.26632967.2
3Display Results1031030.0462239.1
 (SQL Overall)1786911033.70248268.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.