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
charterer1419732(None) 
chartered15158391chartered
charterers15146051charterers
chatterer14196841chatterer
barterer102711632_barterer
careerer1038582c_areerer
caterer92815942c_a_terer
chafferer20133922chafferer
chamferer19154692chamferer
chaptered17176792chaptered
charter123918302chart__er
charters134115582charter_s
chastener1445702chastener
chattered15197992chattered
chatterers15205462chatterers
clatterer11186982clatterer
quarterer18145712quarterer
shatterer12177202shatterer
alterer72713993__alterer
banterer102811773_banterer
bartered113113013_bartered
barterers11269633_barterers
batterer102713213_batterer
cantered113415983c_antered
caperer113013403c_a_perer
capturer1246093c_apturer
careener1039323c_areener
career85822243c_ar_e_er
careered1139493c_areered
careerers1137243c_areerers
carter84932273c_art__er
carters95327253c_arter_s
catered103117773c_a_tered
caterers102814403c_a_terers
chaffered21154483chaffered
chafferers21153173chafferers
chambered19145993chambered
chamfered20165063chamfered
chamferers20153953chamferers
channeler1444603channeler
chanter123919733chant__er
chanters134016743chanter_s
chapter144213853chapt__er
chapteral1644703chapteral
chapters154012133chapter_s
character1645883character
charactered1952873charactered
charger133914063char__ger
chargers144011323charger_s
charier124317903char__ier
charioteer1552753chariote_er
charmer144913663char__mer
charmers154211333charmer_s
charred134614483char__red
charrier1378683char_rier
charted135116853chart__ed
chartering16109253chartering
chastened1545883chastened
chasteners1554793chasteners
chaster124718503chast__er
chastiser1444373chastiser
chatter124416643cha_t_ter
chatters134213953chatter_s
chattery16357273chatter_y
chattier1337513cha_ttier
cheerer123511753ch__eerer
chertier1387873chert_ier
chittered15166413chittered
chortler13336843chort_ler
chuntered1536663chuntered
clamberer15185273clamberer
clattered12178403clattered
clatterers12155423clatterers
cratered1149683cra_tered
falterer11239853_falterer
flatterer12187673flatterer
gartered10319583_gartered
haltere103614703_haltere_
haltered123112553_haltered
halteres113414593_halteres
hammerer15278143_hammerer
hamperer15379093_hamperer
hankerer15248233_hankerer
harborer1348053_harborer
hardener1238883_hardener
harkener1537573_harkener
hastener11259133_hastener
heartener1256763heartener
palterer102411273_palterer
parterre1036983_parterre
patterer103112173_patterer
plasterer1178103plasterer
quartered19155963quartered
quarterers19124823quarterers
rechartered17153163rechartered
scatterer11186293scatterer
sharpener1444583sharpener
shattered13178203shattered
shatterers13185723shatterers
shelterer1245033shelterer
shortener1245773shortener
smatterer11185813smatterer
unchartered1742833unchartered
waterer103314073_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.423422437.4
2DLD Change Limit1486411057.56319653.7
3Display Results1051050.0462282.6
 (SQL Overall)1786911058.03222247.4
 
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.