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

400 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
mitering11301540(None) 
metering112915631metering
mitring103514141mit_ring
altering91917112altering
bitewing1435292bitewing
bittering122511992bittering
catering112019902catering
dithering1499852dithering
entering91920052entering
filtering13199722filtering
iteming1037752_iteming
jittering17218422jittering
littering102411982littering
livering122012382livering
loitering1039682loitering
mastering122315302mastering
mattering122314052mattering
maturing1139952maturing
metring103215292met_ring
mimeoing1336142mimeoing
minoring11311472minoring
miring93723802mi__ring
misterming1538602misterming
mothering152110182mothering
motoring11410952motoring
mustering122212332mustering
muttering122611322muttering
nidering10510482nidering
petering112516812petering
sintering101014802sintering
sistering101213752sistering
tiering8315252ti_ering
tittering102310312tittering
unmitering1345002unmitering
uttering91613082uttering
waitering13310712waitering
watering122316312watering
wintering13412362wintering
withering16108812withering
adhering1338883adhering
airing74927503ai__ring
angering102113803angering
anteing8312813ante_ing
attiring939483attiring
bantering122414233bantering
bartering122313643bartering
battering122715143battering
bettering122212753bettering
bickering1837663bickering
birring103713063bi_rring
bitching163610623bitching
bitewings1542943bitewings
biting95321823bit__ing
bitting103717293bit_ting
blistering13107063blistering
blithering16116123blithering
bothering152210203bothering
bowering142911713bowering
buttering122312523buttering
cantering122417373cantering
capering132414963capering
centering122915143centering
cering94522533__cering
cheering143612703cheering
chittering16107183chittering
cindering13311223cindering
cinerin9313823cinerin_
cinerins10414103cinerins
ciphering17217703ciphering
citing94220183cit__ing
citrin82615413cit_rin_
citrine92514023cit_rine
citrins92614363cit_rins
cohering142413833cohering
covering142215723covering
cowering142514033cowering
cratering12312653cratering
daikering1536103daikering
deterging1237853deterging
deterring1138623deterring
diapering1339033diapering
dickering1737463dickering
dieing84018653di_e_ing
dieting93616833di_eting
differing1746473differing
ditching15349943ditching
dittoing1036263dittoing
diverging15226693diverging
diverting142410333diverting
dizening19177143dizening
dowering132510613dowering
embittering1642943embittering
emitting112410353emit_ting
faltering132211113faltering
fathering161010093fathering
festering132413173festering
fettering132310513fettering
fevering152510083fevering
figuring1336283figuring
fileting1239303fileting
fingering1439193fingering
firing104021723fi__ring
fitting113516563fit_ting
fleering123811283fleering
flittering1486503flittering
fostering132411263fostering
frittering14105623frittering
gartering112111573gartering
gathering1499463gathering
gettering112310033gettering
gibbering1534713gibbering
gieing83614853gi_e_ing
gingering1238873gingering
gitting93215703git_ting
glistering12106423glistering
glittering1296003glittering
guttering112410443guttering
haltering132212003haltering
havering152211053havering
hieing104216623hi_e_ing
hindering14310273hindering
hireling121210993hireling
hiring104421603hi__ring
hitching173310523hitching
hitting113017273hit_ting
homering141512073homering
hovering151911143hovering
imbittering1642353imbittering
imitating1238763imitating
immerging1544103immerging
immersing1445123immersing
immuring1335533immuring
impeding1436563impeding
inhering12913713inhering
interning10315253interning
interring10315423interring
inuring81213013_inuring
iring66025423_i__ring
itching134011683_itching
iterant7317783_iterant
iterating10314253_iterating
jeering153513043_jeering
jiggering1934303jiggering
kippering18205443kippering
kithing153411553kit_hing
kiting114117093kit__ing
kitling123313573kit_ling
kittening1434593kittening
kitting123214443kit_ting
kittling1336063kittling
lagering102212313lagering
latening9711493latening
lathering13912253lathering
layering122310353layering
leering83417643_leering
leistering1147983leistering
lettering102112073lettering
levering122212503levering
libeling1139873libeling
lightering15246113lightering
likening13246893likening
limbering1488793limbering
lingering11310513lingering
lippering14217883lippering
listening10128953listening
lithoing1236743lithoing
livening12248153livening
lowering122210913lowering
lustering102711203lustering
majoring1836363majoring
mammering1337333mammering
manuring1139223manuring
marring103319553m_arring
martyring1535783martyring
matching163512393matching
material10314103material
materiel10311253materiel
mating94832913mat__ing
matting103620143mat_ting
meeting103314963m_eeting
mentoring1239543mentoring
merging112711763m__erging
merino8315093m__erino
metaling111613723metaling
meting94320593m__eting
mewing123914203m__ewing
miaouing1134893miaouing
miaowing1434593miaowing
miauling1137343miauling
miching152911803mi_ching
middling13249343middling
miffing16298403mi_ffing
miking134218463mi__king
mildening1345673mildening
mildewing1643733mildewing
milding113615453mi_lding
milking143712763mi_lking
milling103223683mi_lling
milting103619123mi_lting
miming114317263mi__ming
mincing123314333mi_ncing
minding113317893mi_nding
mingling122010933mingling
mining94225453mi__ning
ministering1445543ministering
minting103020813mi_nting
minuting1139723minuting
mirin75023153mi__rin_
mirins83918903mi__rins
mirroring1246193mirroring
misaltering1445123misaltering
miscuing1338733miscuing
misdoing1238803misdoing
miseating121215433miseating
misentering1446373misentering
miseries10320403miseries
misfiring1536973misfiring
mishearing1647883mishearing
mislying1437843mislying
misprint12912973misprint
missing103619073mi_ssing
missteering1444453missteering
mistaking1699693mistaking
mistending1447953mistending
mistiming1438913mistiming
misting103623383mi_sting
mistuning1237673mistuning
mistyping1744723mistyping
misusing1138893misusing
miter75734793miter___
mitered103213233miter_ed
miterer92511333miter_er
miterers10219683miterers
miters84328783miter__s
mixing164713943mi__xing
mizzling19255443mizzling
modeling12311073modeling
modeming1437103modeming
moistening1346233moistening
moldering1367863moldering
mongering13310353mongering
monitoring1346233monitoring
mooring102514443m_ooring
mortaring1237943mortaring
moseying1436853moseying
motherings16255643motherings
motiving1437163motiving
motorings1245973motorings
mottling11197753mottling
murdering1357133murdering
muring95120373m__uring
murthering1644473murthering
mutating112211753mutating
muting93921523mut__ing
mutining11310493mutining
nattering102212213nattering
neutering1038963neutering
nickering1636573nickering
niddering1255323niddering
niderings1175403niderings
niffering1645133niffering
niterie7313743niteri_e
niteries8318383niteries
ochering14219393ochering
offering1536393offering
omitting11217743omit_ting
ordering1039353ordering
outring84021023out_ring
overing111918053_overing
oystering1337563oystering
paltering122612893paltering
papering132213313papering
pattering122314423pattering
peering103520353_peering
peltering122011673peltering
pestering122315663pestering
philtering1646253philtering
picturing1436033picturing
piecing12410453pi_ecing
pieing93917653pi_e_ing
piercing1346663pi_ercing
pilfering1536393pilfering
piperine122011833piperine
pitching163411113pitching
pithing134014053pit_hing
pitting103618873pit_ting
pitying132910243pit_ying
portering122012303portering
pothering151911283pothering
pottering122612003pottering
powering142210803powering
pterin81014153_pterin_
pterins9812993_pterins
puttering122611643puttering
queering1838203queering
quivering2235873quivering
retearing102214253retearing
retiring92717413retiring
revering122918073revering
ripening1138573ripening
riverine11310803riverine
riveting12139443riveting
rogering10310273rogering
roistering1148583roistering
sabering112113743sabering
sering74731813__sering
severing122013853severing
sewering122411093sewering
sheering123715103sheering
shivering1637333shivering
sideling101012183sideling
sieging92613203si_eging
sieving112311233si_eving
silvering1337923silvering
simmering1467823simmering
simpering1449293simpering
sinewing1267593sinewing
siring75128313si__ring
siting74126623sit__ing
sitting83519633sit_ting
skittering1535393skittering
slithering1496893slithering
slivering1338083slivering
smattering1397583smattering
smiting103014443smit__ing
smothering1646013smothering
sneering93414503sneering
sobering111912783sobering
speering113116323speering
sphering142811943sphering
spiering112713353spiering
staring84527053_staring
steering93916793steering
sterling93615553_sterling
stewing113412493_stewing
stirring9299653stirring
storing83921123_storing
string75327563_st_ring
supering11317683supering
suturing9310373suturing
swithering17105213swithering
tabering112211423tabering
tapering112112503tapering
taring73932283__taring
tattering102212323tattering
tearing84021493__tearing
teeing73916973__teeing
teetering10239893teetering
tentering102313203tentering
terming104016003__terming
tethering1339133tethering
tewing103914823__tewing
tieing73518763ti_e_ing
tillering1037883tillering
timbering14117723timbering
tinkering1437703tinkering
tiring74023093__tiring
tithing113513893tit_hing
titling83715793tit_ling
tottering10229613tottering
towering122610873towering
tutoring938433tutoring
twittering1444583twittering
tyring104613023__tyring
ulcering1139333ulcering
umbering1399433umbering
unmitring1245263unmit_ring
untiring9312003untiring
uptearing1236103uptearing
ushering1258923ushering
uterine7315193_uterine
veering113213683_veering
viewing1437073vi_ewing
viperine13189713viperine
viseing11299163vise_ing
visoring1238373visoring
vitrine102511363vit_rine
vittling1236143vittling
vizoring2134573vizoring
wafering15208893wafering
wagering13219523wagering
waterings13229253waterings
wavering152410543wavering
weltering13219493weltering
westering132112643westering
whitening1635103whitening
whitewing1943853whitewing
widening13237833widening
wildering1456743wildering
wiring104521023wi__ring
witching173410633witching
withing143814493wit_hing
witing103522823wit__ing
witling113215813wit_ling
witting113417063wit_ting
wizening21255463wizening
wuthering1697803wuthering
yattering132410443yattering
yirring11307763yi_rring
zippering23215203zippering

Search took 7 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 Limit1461624006.36022981.4
3Display Results4004000.1732312.1
 (SQL Overall)1786914006.95325699.8
 
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.