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

357 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
omitted1034789(None) 
emitted103010851emitted
omitter9298501omitter
admitted1234762admitted
bitted94418482_bitted
committed1645722committed
demitted12288772demitted
emitter93211082emitter
fitted104716662_fitted
flitted114011642flitted
fritted113611332fritted
gitted84015052_gitted
gritted94110902gritted
imitated1138262imitated
kitted115114832_kitted
knitted12337422knitted
matted94521412_matted
milted93919942_milted
minted94220582_minted
misted93625822_misted
mitred94414342_mitred
mitten83914092_mitten
omitters10277652omitters
opiated1039482opiated
pitted94319592_pitted
quitted17339892quitted
remitted113312072remitted
shitted114212052shitted
slitted83513312slitted
smitten936692smitten
smutted1037462smutted
spitted103912702spitted
twitted11326632twitted
vomited1337252vomi_ted
witted104216812_witted
abetted1058323abetted
abutted1056983abutted
admittee1145133admittee
admitter1135113admitter
agisted938203agisted
agitated1038413agitated
airted74214503_airted
amities9317383amities
aviated11310263aviated
baited95319243bai_ted
batted95623653_batted
befitted14305723befitted
bemisted1368383bemisted
betted94721163_betted
bitten84715123_bitten
bitter84622673_bitter
blatted104812713blatted
blitzed19336533blitzed
blotted103911833blotted
brittled11186093brittled
butted94722063_butted
catted95422473_catted
chatted133411893chatted
chitter124112963chitter
cisted95217523_cisted
cited84421953_ci_ted
citied94014143_citied
clotted104011823clotted
coadmitted16112383coadmitted
cogitated1346323cogitated
combated1539823combated
combatted1644653combatted
comities12317793comities
committee1546243committee
commuted15288983commuted
competed154113593competed
compted143813523com_pted
computed154110953computed
critter94113033critter
cuittled1133993cuittled
dieted83115493_dieted
dimwitted1642293dimwitted
dinted84419843_dinted
dittoed936733_dittoed
doited85016633doi_ted
dominated1339883dominated
dotted84717523_dotted
dratted9358593dratted
drifted12367953drifted
duetted937023duetted
edited83913673edi_ted
embitter12245623embitter
emitters10349643emitters
emoted94614923em_oted
emptied1297393emptied
evicted1337243evicted
evited104013143evi_ted
existed1538473existed
exited144712523exi_ted
fainted114211723fainted
faithed1437163faithed
fatted105419843_fatted
feinted11379623feinted
fetted104817893_fetted
fisted104218703_fisted
fitter94120033_fitter
flatted114012943flatted
flinted114411893flinted
flirted11428673flirted
flited104616583fli_ted
flitter103413903flitter
foisted113210603foisted
foliated1249913foliated
fomented1437803fomented
fomite113314073fomi_te_
fomites123613203fomi_tes
formatted1544883formatted
fretted113411853fretted
fritter103912773fritter
gaited84416923gai_ted
gifted114510703_gifted
girted83912873_girted
glinted9399373glinted
glitter84211803glitter
glitzed18375493glitzed
glutted937243glutted
grifted12379583grifted
gritter83913353gritter
gutted84716363_gutted
hatted104921513_hatted
heisted113210653heisted
hilted104016043_hilted
hinted104318323_hinted
histed104420243_histed
hitter94419863_hitter
hoisted113411293hoisted
hotted104319943_hotted
hutted104616333_hutted
imbitter12265283imbitter
imitate9310873imitate_
imitates10310503imitates
imputed1236533imputed
jetted143915083_jetted
jilted144111353_jilted
jitter133314993_jitter
jointed15378503jointed
joisted15379173joisted
jotted143615173_jotted
jutted144315023_jutted
kilted113613833_kilted
kited105120093_ki_ted
kithed144613013_kithed
kittel10368873_kittel
kitten104611483_kitten
kittled12388193_kittled
knitter11348133knitter
knotted12357233knotted
letted74118543_letted
lifted104413523_lifted
lilted73715373_lilted
limited102310233limited
linted74021823_linted
listed74322833_listed
litten64014873_litten
litter64324853_litter
lotted74222403_lotted
malted94819863_malted
marted94425213_marted
masted94025803_masted
mated85537783_m_ated
matte75626843_matte_
matter84325343_matter
mattes85624533_mattes
meated94222403_meated
melted94219063_melted
meted85424433_m_eted
metred95315143_metred
mettled103510543_mettled
miched143913393_miched
miffed15398713_miffed
miked125020453_mi_ked
milded104416153_milded
milked134612573_milked
milled94326173_milled
milter84921233_milter
mimed105622733_mi_med
minced114114913_minced
minded103817833_minded
mined85333353_mi_ned
minter84425103_minter
minuted10329503_minuted
mired85729223_mi_red
misfed124113023_misfed
misled94719313_misled
missed94423603_missed
mistend103812523_mistend
mister84728563_mister
mite66249413_mi_te_
miter75734793_mi_ter
mitered103213233_mitered
mites75141803_mi_tes
mither114218563_mither
mitier83620673_mitier
mitre75522423_mitre_
mitres83922073_mitres
mitt66145493_mitt__
mittened1136363_mittened
mittens9349883_mittens
mitts75523753_mitt_s
mixed155717253_mi_xed
moated94819003_moated
moiled94318863moi_led
moisten93110143moisten
moister94015373moister
molted94217473_molted
mooted94120373_mooted
motived13357763motived
motte75526973_motte_
mottes85523693_mottes
mottled10409973mottled
moulted103310313moulted
mounted103611533mounted
mouthed133811043mouthed
musted93321073_musted
mutated102712253_mutated
muted85023383_m_uted
mutter84418883_mutter
netted74118713_netted
nominated1239283nominated
nutted74316973_nutted
obviated1444563obviated
oersted839553oersted
oiled64429473o_i_led
oinked114213283o_inked
omened93711003om_ened
omit65337373omi_t__
omits75018263omi_t_s
omitting11217743omitting
opiate8513463opiate_
opiates9312143opiates
opined95113853opi_ned
opted84914273o__pted
orated74221503o_rated
orbited1037733orbited
oriented937483oriented
osiered837123osiered
otter54423973o__tter
oughted1236223oughted
ousted73720583o_usted
outed65429063o__uted
outfitted1345193outfitted
outled74020343o_utled
outwitted1345133outwitted
oxidated1745033oxidated
painted104214633painted
patted94724683_patted
permitted1446653permitted
petted94121523_petted
pithed124615613_pithed
pitied94017253_pitied
platted103614263platted
plotted104612373plotted
pointed103813983pointed
posited10511493posi_ted
potted94624013_potted
printed104016373printed
putted94220253_putted
quieted17309723quieted
quilted17319313quilted
quirted17369213quirted
quitter162910753quitter
ratted74923343_ratted
reemitted1245943reemitted
refitted12309413refitted
reminted113615083reminted
remitter102810323remitter
retted74826313_retted
rifted104115313_rifted
rioted73416373_rioted
ritter63822423_ritter
rotted74524433_rotted
rutted74518403_rutted
sainted84114243sainted
scatted103512773scatted
shifted14359983shifted
shotted113912403shotted
sifted104313673_sifted
silted74020013_silted
sited65130743_si_ted
sitten64113823_sitten
sitter63323383_sitter
skirted12388613skirted
skited114313483ski_ted
skitter113810403skitter
slatted84015183slatted
slitter73615873slitter
slotted84613883slotted
smarted105012613smarted
smatter93613333smatter
smelted10399093smelted
smiled93716433smi_led
smirked14307233smirked
smite75224873smi_te_
smiter83616413smi_ter
smites83921923smi_tes
somite84519373somi_te_
somites94219123somi_tes
sopited104211063sopi_ted
sotted74121403_sotted
spatted104014143spatted
spirted103913073spirted
spited94820443spi_ted
spitter94015183spitter
spotted103713143spotted
stetted82610403stetted
stilted83511473stilted
stinted82914193stinted
stotted83511423stotted
submitted1445233submitted
suited74019423sui_ted
swatted114110693swatted
swotted11398713swotted
tainted83512423tainted
tatted74920533_tatted
tilted74616863_tilted
tinted74419533_tinted
tithed104115593_tithed
titled73815003_titled
titter63421163_titter
toited74016753toi_ted
tomcatted1442063tomcatted
totted74319953_totted
trotted83711283trotted
tutted75117443_tutted
twisted11277433twisted
twitter10278093twitter
unbitted1138213unbitted
unfitted1238163unfitted
united74421543uni_ted
unmatted1138293unmatted
unmitred1136843unmitred
unpitted1148623unpitted
unwitted1237543unwitted
vatted104214733_vatted
vetted104316323_vetted
vittled11347343_vittled
vomiter1237953vomi_ter
waisted114210943waisted
waited103819773wai_ted
wetted103717023_wetted
whetted14256693whetted
whisted144010013whisted
whited134814083whi_ted
whitter139110893whitter
whittled1594913whittled
wilted103915713_wilted
wisted104120273_wisted
wited94727143_wi_ted
withed134416233_withed
wotted104115713_wotted
writhed14389623writhed
written10336343written

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 Filter1786911340270.406440125.6
2DLD Change Limit1340273576.26621389.6
3Display Results3573570.1402550.0
 (SQL Overall)1786913576.81226231.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.