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

242 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
cratering1231265(None) 
catering112019901c_atering
craterings1346001craterings
bartering122313642bartering
cantering122417372cantering
capering132414962c_apering
careering12311202careering
centering122915142centering
chaptering18107962chaptering
chartering16109252chartering
chattering16108642chattering
clattering13109232clattering
clavering1538372clavering
crating103725202crat__ing
cravening1547552cravening
gartering112111572gartering
watering122316312_watering
altering91917113_altering
armaturing1353973armaturing
bantering122414233bantering
barbering14229683barbering
battering122715143battering
beavering1538703beavering
bettering122212753bettering
bittering122511993bittering
blathering16107583blathering
blattering13108713blattering
brattling1236003brattling
brazening2185183brazening
brokering1636283brokering
brothering1646033brothering
buttering122312523buttering
cageling12310843c_ageling
cambering16109873cambering
cameoing1379063c_ameoing
cankering162110793cankering
capturing1436623capturing
careening12310013careening
caring95137993c_a__ring
carpeting1439483carpeting
carting104228283cart__ing
cartoning12311113cartoning
catching163712773c_atching
cateran9313773c_ateran_
caterans10313223c_aterans
catling104819793c_at_ling
catting103922643c_at_ting
caverning1536283c_averning
centerings13247663centerings
centring112112953cent_ring
cering94522533c___ering
chaffering22104643chaffering
chairing143110773cha_iring
chambering20116043chambering
chamfering21125333chamfering
charactering2053713charactering
charing133721323cha__ring
charring142913163cha_rring
chastening1656523chastening
chatting142810143chat_ting
cheering143612703c_heering
chittering16107183chittering
chuntering1647803chuntering
cindering13311223cindering
ciphering17217703ciphering
clabbering17104583clabbering
clambering1776163clambering
clamoring1477423clamoring
cloturing1245473cloturing
clustering13116813clustering
cluttering13106833cluttering
coating103525313coat__ing
cockering1839693cockering
coffering1838043coffering
cohering142413833c_ohering
compering163414163compering
coopering142611323coopering
coppering162810893coppering
cornering12311893cornering
coshering15510023coshering
countering13314473countering
covering142215723c_overing
cowering142514033c_owering
craaling112711353cra_aling
crabbing15287933cra_bbing
cracking174013903cra_cking
crackling18157003crackling
cradling122411453cra_dling
crafting143710173cra_fting
cramming15339433cra_mming
cramping153411853cra_mping
cranching17278733cranching
craning103620303cra__ning
cranking154613073cra_nking
crankling16147293crankling
craping124018713cra__ping
crapping153911453cra_pping
crashing143512633cra_shing
crater85026643crater___
cratered1149683crater_ed
craterlet1148413craterlet
craterlike1644013craterlike
craters95021893crater__s
craving134015733cra__ving
crawling143110513cra_wling
crayoning1535243crayoning
crazing193914583cra__zing
creating113921953creat__ing
creeling113513363cr_eeling
creeping133310103cr_eeping
creneling1247733creneling
creping122913653cr__eping
crewing133212633cr__ewing
criteria1047993criteri_a
criterial1148153criterial
criterion1145293criterion
criterions1244763criterions
criterium1346393criterium
crutching17216073crutching
culturing1236553culturing
cumbering16108203cumbering
curating11314293curat__ing
cyphering20175243cyphering
dewatering1545773dewatering
diapering1339033diapering
dratting10389663drat_ting
elaterin849903elaterin_
elaterins9410033elaterins
entering91920053_entering
faltering132211113faltering
fathering161010093_fathering
feathering17108793feathering
featuring1337323featuring
festering132413173festering
fettering132310513fettering
filtering13199723filtering
flattering1498743flattering
fostering132411263fostering
fracturing1643933fracturing
frittering14105623frittering
garnering11298083garnering
gathering1499463_gathering
gettering112310033gettering
grating93923183grat__ing
graveling1457383graveling
greatening1245443greatening
guttering112410443guttering
haltering132212003haltering
havering152211053_havering
jittering17218423jittering
laagering1136833laagering
lagering102212313_lagering
latening9711493_latening
lathering13912253_lathering
layering122310353_layering
leathering1488683leathering
lettering102112073lettering
littering102411983littering
loitering1039683loitering
lustering102711203lustering
martyring1535783martyring
mastering122315303mastering
mattering122314053mattering
maturing1139963_maturing
metering112915633_metering
mitering113015403_mitering
mustering122212333mustering
muttering122611323muttering
nattering102212213nattering
neatening1038353neatening
neutering1038963neutering
orating83520323orat__ing
ordering1039353or_dering
oystering1337563oystering
paltering122612893paltering
papering132213313_papering
partnering1345553partnering
pattering122314423pattering
peltering122011673peltering
pestering122315663pestering
petering112516813_petering
plastering1339243plastering
portering122012303portering
pottering122612003pottering
prating103424453prat__ing
prattling1246303prattling
prealtering1446173prealtering
puttering122611643puttering
quartering2045843quartering
quavering2235953quavering
rapturing1245363_rapturing
raring74332873_ra__ring
rating74938703_rat__ing
rattening10288763_rattening
ratting83822363_rat_ting
rattling92510873_rattling
raveling123414373_raveling
ravening122611293_ravening
razeeing1834363_razeeing
razoring1836443_razoring
realtering1139473realtering
retearing102214253_retearing
retiring92717413_retiring
revering122918073_revering
rogering10310273_rogering
sabering112113743_sabering
scarpering1545413scarpering
scattering1398013scattering
sceptering1545793sceptering
scratching1844533scratching
scuttering1386633scuttering
shattering1498283shattering
sintering101014803sintering
sistering101213753sistering
slathering14108283slathering
slavering1338723slavering
smattering1397583smattering
spattering13107793spattering
tabering112211423_tabering
tapering112112503_tapering
tattering102212323tattering
teetering10239893teetering
tentering102313203tentering
tittering102310313tittering
tottering10229613tottering
trailering1145723trailering
trameling1249053trameling
trapesing1247263trapesing
traveling1349053traveling
traversing1444803traversing
uttering91613083_uttering
wafering15208893_wafering
wagering13219523_wagering
waitering13310713waitering
waterings13229253_waterings
wavering152410543_wavering
weathering1798353weathering
weltering13219493weltering
westering132112643westering
wintering13412363wintering
wrathing15248923wrat_hing
yattering132410443yattering

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.420425454.8
2DLD Change Limit1486412426.64322375.6
3Display Results2422420.1062283.0
 (SQL Overall)1786912427.16924925.5
 
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.