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

260 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
raftered123767(None) 
altered83215752_altered
bantered113313652bantered
bartered113113032bartered
battered113315072battered
cantered113415992cantered
catered103117782ca_tered
cratered1149692cra_tered
faltered122811002faltered
gartered10319602gartered
haltered123112572haltered
mastered112614012mastered
mattered112412912mattered
nattered92011632nattered
paltered113012502paltered
pattered112714212pattered
rafted104714702raft__ed
rafter94517582rafter__
rafters103715632rafter_s
rapiered1136052rapiered
raptured1155472raptured
rattened9218622rattened
realtered1037902realtered
tattered92011452tattered
wafered14288432waf_ered
waitered1238762waitered
watered113014962wa_tered
yattered12239542yattered
adhered1239233_adhered
afeared1176833_afeared
after85719793_after__
afters94717073_after_s
alterer72714013_alterer
angered93013473_angered
anteed75616113_ante_ed
antired82316193_antired
antlered938263_antlered
attired8238913_attired
badgered1336213badgered
bannered11299323bannered
banterer102811783banterer
barbered13259553barbered
barterer102711653barterer
battened11259573battened
batterer102713223batterer
bettered113011843bettered
bistered112913333bistered
bittered112711833bittered
blattered12198583blattered
buffered1764993buffered
buttered112712633buttered
caftaned1445093caftaned
cambered15129003cambered
cancered132411553cancered
cankered153010223cankered
capered123014043ca_pered
captured1336573captured
careered1139503careered
caterer92815953ca_terer
centered112513523centered
chaffered21154483chaffered
chaptered17176803chaptered
chartered15158403chartered
chattered15198003chattered
clattered12178423clattered
coffered1737673coffered
cottered112511743cottered
crafted13419773craft__ed
crafter124111333crafter__
crafters13419953crafter_s
dackered16116893dackered
dafter104813343dafter__
daggered12246403daggered
daikered1495223daikered
dandered112110963dandered
dangered11248513dangered
differed1635523differed
drafted12439033draft__ed
draftee11379523drafte_e_
draftees12225253drafte_es
drafter11449433drafter__
drafters12338533drafter_s
entered82718883_entered
factored1436233factored
falterer11239873falterer
fastened12257853fastened
fathered151510433fathered
fattened12268283fattened
festered122512113festered
fettered12259493fettered
filtered12259043filtered
flattered13188643flattered
fostered122210453fostered
fractured15125063fractured
frittered13205163frittered
gandered112211173gandered
garnered10247123garnered
gathered13149383gathered
gauffered1741873gauffered
gettered10258613gettered
goffered1634523goffered
grafted124110223graft__ed
grafter114211153grafter__
grafters12409193grafter_s
guttered10259173guttered
hafted134713833haft__ed
hafter124815883hafter__
hafters134614333hafter_s
haltere103614713haltere_
halteres113414603halteres
hammered16218853hammered
hampered16239933hampered
hankered16289443hankered
hastened12239103hastened
hatred104814333ha_t_red
havered144011453ha_vered
jabbered2034433jabbered
jittered16267223jittered
kashered1636403kashered
laagered1055853laagered
lackered15108683lackered
laddered1136743laddered
lagered92311153la_gered
lappered13288213lappered
latened8711923la_tened
laterad8310853la_terad
lathered121512333lathered
laveered1235253laveered
lawyered1534033lawyered
layered11259413la_yered
lettered92910783lettered
littered92511383littered
loitered938183loitered
lustered92510613lustered
mammered12237653mammered
mannered11249653mannered
martyred1434293martyred
matured10310043ma_tured
metered103514013_metered
mitered103213233_mitered
mustered112511513mustered
muttered112610803muttered
natured838963na_tured
neutered937423neutered
niffered1544143niffered
offered1436143_offered
oystered1236923oystered
palterer102411293palterer
pampered15229233pampered
pandered121812573pandered
papered122513173pa_pered
partnered1244493partnered
pastored1139973pastored
pastured1138233pastured
pattened11299393pattened
patterer103112183patterer
patterned1265753patterned
paupered13216943paupered
peltered112510453peltered
pestered112814973pestered
petered103314973_petered
plastered1288913plastered
portered112311553portered
pottered112311663pottered
prealtered1344943prealtered
proffered1843433proffered
puttered112611153puttered
quartered19155973quartered
rabbeted1334443rabbeted
racemed1237013ra_cemed
racheted14149513racheted
racketed15169133racketed
raffled14429083raf_fled
raftsmen1343953raftsmen
ragweed1235073ragwe_ed
rancored1137233rancored
ranted74324703rant__ed
ranter63826823ranter__
ranters73323643ranter_s
rappeled1335003rappeled
rapture937393rapture_
raptures1037583raptures
rared65738323ra___red
raster64731443raster__
rasters74629023raster_s
rated65441383ra_t__ed
rater54943283ra_ter__
raters63936583ra_ter_s
ratted74923343ra_t_ted
ratteen7329113ratte_en
rattener8238533rattener
ratter64326313ratter__
ratters74422473ratter_s
rattled84012953ra_ttled
raveled114113633ra_veled
ravened115012283ra_vened
razeed163710013ra_ze_ed
razored1736333ra_zored
reentered1038573reentered
refeed104717623ref_e_ed
referee101615753ref_eree
refereed12149693ref_ereed
referred1297833referred
refiltered1443773refiltered
refired115116993ref_ired
reflexed1975253reflexed
refueled1286573refueled
remastered1345643remastered
rendered102512263rendered
reoffered1643313reoffered
restored96417193restored
retired84620143r_etired
reuttered1036073reuttered
revered112819333r_evered
rifted104115313rift__ed
rogered939553r_ogered
roistered1037653roistered
roystered1344873roystered
rubbered1335383rubbered
ruptured1144683ruptured
sabered103213023sa_bered
safetied1244663safetied
saggered11237553saggered
sauntered1036293sauntered
sauteed8349613saute_ed
scattered12197363scattered
shattered13178213shattered
sintered92213903sintered
sistered92612803sistered
smattered12186793smattered
softened1235663softened
spattered12187653spattered
suffered1536733suffered
tabered103311593ta_bered
tafferel1443123tafferel
tampered13279463tampered
tapered102612933ta_pered
tautened935423tautened
teetered9258303teetered
tentered96412103tentered
tittered9239493tittered
tottered9208703tottered
trailered1045393trailered
unaltered1037733unaltered
uttered82712443_uttered
wafted134012143waft__ed
wafter124114613wafter__
wafters134112813wafter_s
wafture1334853wafture_
waftures1434853waftures
wagered12299333wa_gered
wandered132110793wandered
waterbed1436453wa_terbed
waterer103314083wa_terer
wavered142910433wa_vered
weltered12238443weltered
westered122511873westered
wintered122111573wintered
yabbered1633963yabbered
yammered16225763yammered

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 Filter1786911461620.420425454.8
2DLD Change Limit1461622607.25020160.3
3Display Results2602600.1102363.6
 (SQL Overall)1786912607.78022968.0
 
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.