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

105 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
charterer1419733(None) 
chartered15158401chartered
charterers15146051charterers
chatterer14196841chatterer
barterer102711652_barterer
careerer1038582c_areerer
caterer92815952c_a_terer
chafferer20133922chafferer
chamferer19154692chamferer
chaptered17176802chaptered
charter123918302chart__er
charters134115592charter_s
chastener1445702chastener
chattered15198002chattered
chatterers15205462chatterers
clatterer11186992clatterer
quarterer18145722quarterer
shatterer12177202shatterer
alterer72714013__alterer
banterer102811783_banterer
bartered113113033_bartered
barterers11269643_barterers
batterer102713223_batterer
cantered113415993c_antered
caperer113013403c_a_perer
capturer1246103c_apturer
careener1039333c_areener
career85822243c_ar_e_er
careered1139503c_areered
careerers1137243c_areerers
carter84932273c_art__er
carters95327263c_arter_s
catered103117783c_a_tered
caterers102814413c_a_terers
chaffered21154483chaffered
chafferers21153173chafferers
chambered19145993chambered
chamfered20165063chamfered
chamferers20153953chamferers
channeler1444603channeler
chanter123919733chant__er
chanters134016743chanter_s
chapter144213853chapt__er
chapteral1644703chapteral
chapters154012133chapter_s
character1645883character
charactered1952883charactered
charger133914063char__ger
chargers144011323charger_s
charier124317903char__ier
charioteer1552763chariote_er
charmer144913663char__mer
charmers154211333charmer_s
charred134614493char__red
charrier1378693char_rier
charted135116853chart__ed
chartering16109253chartering
chastened1545883chastened
chasteners1554803chasteners
chaster124718503chast__er
chastiser1444373chastiser
chatter124416643cha_t_ter
chatters134213953chatter_s
chattery16357273chatter_y
chattier1337513cha_ttier
cheerer123511763ch__eerer
chertier1387873chert_ier
chittered15166413chittered
chortler13336843chort_ler
chuntered1536663chuntered
clamberer15185273clamberer
clattered12178423clattered
clatterers12155423clatterers
cratered1149693cra_tered
falterer11239873_falterer
flatterer12187683flatterer
gartered10319603_gartered
haltere103614713_haltere_
haltered123112573_haltered
halteres113414603_halteres
hammerer15278143_hammerer
hamperer15379093_hamperer
hankerer15248233_hankerer
harborer1348063_harborer
hardener1238883_hardener
harkener1537573_harkener
hastener11259143_hastener
heartener1256773heartener
palterer102411293_palterer
parterre1037013_parterre
patterer103112183_patterer
plasterer1178113plasterer
quartered19155973quartered
quarterers19124833quarterers
rechartered17153163rechartered
scatterer11186293scatterer
sharpener1444583sharpener
shattered13178213shattered
shatterers13185723shatterers
shelterer1245043shelterer
shortener1245773shortener
smatterer11185813smatterer
unchartered1742833unchartered
waterer103314083_wa_terer
whatever1742673wha_tever

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 Filter1786911486410.470380193.6
2DLD Change Limit1486411057.84318952.1
3Display Results1051050.0462282.6
 (SQL Overall)1786911058.35921377.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.