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

133 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
chaptered1717679(None) 
chartered15158391chartered
chattered15197991chattered
cantered113415982c_antered
capered123014042c_ap_ered
captured1336572c_aptured
catered103117772c_a_tered
chaffered21154482chaffered
chambered19145992chambered
chamfered20165062chamfered
chapleted1743972chapleted
chapter144213852chapter__
chapteral1644702chapteral
chapters154012132chapter_s
charterer14197322charterer
chastened1545882chastened
chatterer14196842chatterer
chippered1945002chippered
chittered15166412chittered
choppered1964882choppered
chuntered1536662chuntered
clattered12178402clattered
cratered1149682cra_tered
haltered123112552_haltered
shattered13178202shattered
altered83215733__altered
bantered113313633_bantered
bartered113113013_bartered
battered113315053_battered
blattered12198563blattered
cambered15129003c_ambered
cancered132411553c_ancered
cankered153010223c_ankered
caperer113013403c_ap_erer
capture1138913c_apture_
capturer1246093c_apturer
captures1239443c_aptures
careered1139493c_areered
caterer92815943c_a_terer
centered112513523c_entered
chafferer20133923chafferer
chaired134211243cha__ired
chamferer19154693chamferer
channeled1544913channeled
chanted134015953chant__ed
chanter123919733chanter__
chanters134016743chanter_s
chaperon1547353chap_eron
chaperoned1843873chap_eroned
chapiter1536603chapiter__
chapiters1635203chapiter_s
chapped172711443chap__ped
chaptering18107963chaptering
charactered1952873charactered
chared125423693cha___red
charred134614483cha__rred
charted135116853chart__ed
charter123918303charter__
charterers15146053charterers
charters134115583charter_s
chastener1445703chastener
chaster124718503chaster__
chastised1554683chastised
chatted133411893cha_t_ted
chatter124416643chatter__
chatterers15205463chatterers
chatters134213953chatter_s
chattery16357273chatter_y
cheapened1743783cheap_ened
checkered2144683checkered
cheered133713293ch__eered
chequered2442613chequered
chowdered1944013chowdered
ciphered1637053c_iphered
clabbered16184763clabbered
clambered16146133clambered
clatterer11186983clatterer
clavered14187633cla_vered
clustered12186613clustered
cluttered12185943cluttered
coappeared1742273coappeared
coapted123911503coapt__ed
compeered1646303compeered
compered153414923comp_ered
coopered133310933coop_ered
coppered153410543c_oppered
cottered112511733c_ottered
countered12313003countered
cyphered1934653c_yphered
diapered1238003diap_ered
faltered122810983_faltered
flattered13188623flattered
gartered10319583_gartered
haltere103614703_haltere_
halteres113414593_halteres
hammered16218853_hammered
hampered16239933_hampered
hankered16289443_hankered
happened1635653_happened
haptene123810933_haptene_
haptenes133810823_haptenes
hastened12239103_hastened
hatred104814333_ha_t_red
havered144011453_ha_vered
lappered13288213_lappered
mastered112614003_mastered
mattered112412903_mattered
nattered92011623_nattered
paltered113012483_paltered
papered122513173_pap_ered
pattered112714203_pattered
philtered1545493philtered
plastered1288893plastered
quartered19155963quartered
raftered1237663_raftered
rapiered1136053_rapiered
raptured1155463_raptured
realtered1037893realtered
rechartered17153163rechartered
scattered12197353scattered
sceptered1444723sceptered
shatterer12177203shatterer
sheltered1335573sheltered
shuttered13156333shuttered
smattered12186783smattered
spattered12187643spattered
tapered102612933_tap_ered
tattered92011443_tattered
unaltered1037723unaltered
unchartered1742833unchartered
waitered1238753_waitered
watered113014953_wa_tered
yattered12239533_yattered

Search took 8 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.456391866.2
2DLD Change Limit1486411337.23320550.4
3Display Results1331330.0632111.1
 (SQL Overall)1786911337.75223051.0
 
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.