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

291 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
cratered114968(None) 
catered103117771c_atered
bartered113113012bartered
cantered113415982cantered
capered123014042c_apered
careered1139492careered
caterer92815942c_aterer
centered112513522centered
chaptered17176792chaptered
chartered15158392chartered
chattered15197992chattered
clattered12178412clattered
clavered14187632clavered
cottered112511742cottered
crated94827772crat__ed
crater85026642crater__
craterlet1148412craterlet
craters95021892crater_s
cravened1476722cravened
gartered10319592gartered
raftered1237662_raftered
watered113014952_watered
altered83215743_altered
armatured1264623armatured
bantered113313633bantered
barbered13259543barbered
barterer102711633barterer
battered113315053battered
beavered1437503beavered
bettered113011843bettered
bistered112913333bistered
bittered112711833bittered
blathered15168363blathered
blattered12198573blattered
blazered2035063blazered
brattled11196723brattled
brazened20134903brazened
brokered1536083brokered
brothered1546003brothered
buttered112712623buttered
cambered15129003cambered
cameoed1238383c_ameoed
cancered132411553cancered
cankered153010223cankered
caperer113013403c_aperer
captured1336573captured
cared86050093c_a__red
careened1139193careened
careerer1038583careerer
carpeted1338953carpeted
carted98631443cart__ed
carter84932273carter__
carters95327253carter_s
cartoned111312833cartoned
cater74840723c_ater__
cateran9313773c_ateran
caterers102814403c_aterers
cateress102311613c_ateress
caters85336503c_ater_s
catted95422473c_at_ted
caverned1436163c_averned
centred103411683cent_red
cerated103922473cerat__ed
cered85227443c___ered
chaffered21154483chaffered
chaired134211243cha_ired
chambered19145993chambered
chamfered20165063chamfered
charactered1952883charactered
chared125423693cha__red
charred134614483cha_rred
charterer14197323charterer
chastened1545883chastened
chatted133411893chat_ted
chatterer14196843chatterer
cheered133713293c_heered
chittered15166413chittered
chuntered1536663chuntered
cindered1239793cindered
ciphered1637053ciphered
clabbered16184763clabbered
clambered16146133clambered
clamored1336953clamored
clatterer11186993clatterer
clotured11246163clotured
clovered14187363clovered
clustered12186613clustered
cluttered12185943cluttered
coated94927043coat__ed
coatee84327223coate_e_
coatees93816553coate_es
coater84329573coater__
coaters93525793coater_s
cockered17710213cockered
coffered1737673coffered
cohered133514693c_ohered
compered153414923compered
coopered133310943coopered
coppered153410543coppered
cornered11311133cornered
coshered14610293coshered
countered12313003countered
covered133315293c_overed
cowered133214653c_owered
craaled10339423cra_aled
crabbed14388873cra_bbed
cracked163514743cra_cked
crackled17428863crackled
cradled113410813cra_dled
crafted13419773cra_fted
crafter124111333crafter__
crafters13419953crafter_s
cragged12479883cra_gged
crammed143710123cra_mmed
cramped144712183cra_mped
cranched163210413cranched
craned96121653cra__ned
cranked143812843cra_nked
crankled15408153crankled
crannied1137903crannied
craped116120533cra__ped
crapped143912633cra_pped
crashed134214213cra_shed
cratches153012543cratches
crate76537403crat__e_
cratering12312653cratering
craterlets1243503craterlets
crates85736063crat__es
craved125417773cra__ved
craver114618473craver__
cravers124416563craver_s
crawled133710403cra_wled
crayoned1435003crayoned
crazed184714453cra__zed
created104323453creat__ed
creature1038743creature_
creatures1138423creatures
creed85727393cr__e_ed
creeled104012013cr_eeled
creeped12329713cr_eeped
creneled11326893creneled
creped114115713cr__eped
crewed125316563cr__ewed
criteria1048003criteria
crotched16428603crotched
crutched16307463crutched
cultured1137233cultured
cumbered15157963cumbered
curated104717583curat__ed
cyphered1934653cyphered
dewatered1444743dewatered
diapered1238003diapered
draperied1344983draperied
dratted9358593drat_ted
elaterid948613elaterid
entered82718883_entered
faltered122810993faltered
fathered151510433_fathered
feathered16188893feathered
featured1237683featured
festered122512113festered
fettered12259493fettered
filtered12259043filtered
flattered13188633flattered
fostered122210453fostered
fractured15125063fractured
frater94520593frater__
fraters103517213frater_s
frittered13205163frittered
garnered10247113garnered
gathered13149383_gathered
gettered10258613gettered
goateed9307063goate_ed
grated84523923grat__ed
grater74625443grater__
graters85419743grater_s
graveled13417363graveled
greatened1144583greatened
guttered10259163guttered
haltered123112563haltered
hatred104814333_hat_red
havered144011453_havered
heathered16149463heathered
irater65218353irater__
jittered16267223jittered
krater104014313krater__
kraters114212343krater_s
laagered1055853laagered
lagered92311153_lagered
latened8711923_latened
laterad8310843_laterad
lathered121512333_lathered
layered11259413_layered
leathered13148713leathered
lettered92910783lettered
littered92511383littered
loitered938183loitered
lustered92510603lustered
martyred1434283martyred
mastered112614003mastered
mattered112412903mattered
matured10310043_matured
metered103514013_metered
mitered103213233_mitered
mustered112511503mustered
muttered112610793muttered
nattered92011623nattered
natured838963_natured
neatened937043neatened
neutered937423neutered
orated74221503orat__ed
ordered9108533or_dered
oystered1236923oystered
paltered113012493paltered
papered122513173_papered
partnered1244483partnered
pattered112714203pattered
peltered112510453peltered
pestered112814973pestered
petered103314973_petered
plastered1288903plastered
portered112311543portered
pottered112311663pottered
prated94924923prat__ed
prater84825353prater__
praters94921653prater_s
prattled11246533prattled
prealtered1344943prealtered
puttered112611143puttered
quartered19155963quartered
quavered2144813quavered
racemed1237013_racemed
rapiered1136053_rapiered
raptured1155473_raptured
rared65738323_ra__red
rated65441383_rat__ed
rater54943283_rater__
raters63936583_rater_s
ratted74923343_rat_ted
rattened9218623_rattened
rattled84012953_rattled
raveled114113633_raveled
ravened115012283_ravened
razeed163710013_raze_ed
razored1736333_razored
realtered1037893realtered
retired84620143_retired
revered112819333_revered
rogered939553_rogered
sabered103213023_sabered
scarpered1435113scarpered
scattered12197353scattered
sceptered1444723sceptered
scratched1735393scratched
scuttered12166423scuttered
shattered13178203shattered
sintered92213903sintered
sistered92612803sistered
slathered13148553slathered
slavered12188033slavered
smattered12186783smattered
spattered12187643spattered
tabered103311593_tabered
tapered102612933_tapered
tattered92011443tattered
teetered9258303teetered
tentered96412103tentered
tittered9239493tittered
tottered9208703tottered
traceried1247143traceried
trailered1045393trailered
trameled11309073trameled
trapesed1136473trapesed
traveled12349453traveled
traversed1344563traversed
unaltered1037723unaltered
uncatered1237403uncatered
unwatered1345683unwatered
uttered82712433_uttered
wafered14288433_wafered
wagered12299333_wagered
waitered1238753waitered
waterbed1436443_waterbed
waterer103314073_waterer
wavered142910433_wavered
weathered16168513weathered
weltered12238433weltered
westered122511873westered
wintered122111573wintered
wrathed14298523wrat_hed
yattered12239533yattered

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 Filter1786911461620.440406115.9
2DLD Change Limit1461622918.23317753.2
3Display Results2912910.1262309.5
 (SQL Overall)1786912918.79920308.1
 
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.