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

109 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
charter12391830(None) 
carter84932271c_arter
chanter123919731chanter
chapter144213851chapter
charger133914061charger
charier124317901charier
charmer144913661charmer
charted135116851charted
charters134115581charters
chaster124718501chaster
chatter124416641chatter
barter85525382_barter
canter85230112c_anter
carder94524182c_arder
career85822242c_areer
carer74942332c_ar_er
carper104923632c_arper
carte75940422c_arte_
carted98631442c_arted
cartel85022532c_artel
carters95327252c_arters
cartes86239472c_artes
carver114420152c_arver
caster85232572c_aster
cater74840722c_a_ter
chafer144714572cha_fer
chaffer18389472chaffer
chamber164011062chamber
chamfer17399862chamfer
champer163813412champer
chancer144215632chancer
changer134215542changer
chanted134015952chanted
chanters134016742chanters
chantey154112542chantey
chantor123710312chantor
chapiter1536602chapiter
chapters154012132chapters
character1645882character
chare105231982char_e_
chared125423692char_ed
chares115631802char_es
charge125114212charge_
charged144614022charged
chargers144011322chargers
charges134615982charges
charked174814012charked
charley15118272charley
charmed154714252charmed
charmers154211332charmers
charnel124010052charnel
charr104821782char__r
charred134614492charred
charrier1378692charrier
chart105038282chart__
chartered15158392chartered
charterer14197322charterer
charts115823092chart_s
chaser114918382cha_ser
chaste114617392chaste_
chasten124312402chasten
chatted133411892chatted
chattel12388892chattel
chatters134213952chatters
chattery16357272chattery
chattier1337512chattier
chaufer15347942chaufer
chaunter1366392chaunter
chawer144314412cha_wer
cheater124816962cheater
chertier1387872chertier
chirker16429322chirker
chirper14359962chirper
chitter124112962chitter
chorten122811302chorten
chortler13336842chortler
chunter123911482chunter
churner12298342churner
clatter94014972clatter
coarser93211202coarser
coaster94219042coaster
coater84329572coa_ter
courter94516482courter
crafter124111332crafter
crater85026642cra_ter
curter85320082c_urter
darter75320362_darter
garter74420512_garter
hafter124815882_hafter
halter94420882_halter
harder105022402_harder
harmer114719552_harmer
harper115018402_harper
hater85034752_ha_ter
hatter94724872_hatter
hurter93915852_hurter
pearter9412742pearter
phatter123810202phatter
quarter163211852quarter
recharter1466892recharter
sharer95025482shar_er
sharker144313812sharker
sharper124312702sharper
shatter103615702shatter
shorter103515502shorter
smarter94113132smarter
starter73817882starter
tarter64023562_tarter
thwarter1433392thwarter

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.376475242.0
2DLD Change Limit1076711092.84337872.3
3Display Results1091090.0462369.6
 (SQL Overall)1786911093.26554729.2
 
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.