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

301 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
omitting1121774(None) 
emitting112410351emitting
admitting1345032admitting
bitting103717292_bitting
committing1746682committing
demitting13239072demitting
fitting113516562_fitting
flitting123010882flitting
fritting123510702fritting
gitting93215702_gitting
gritting10309982gritting
hitting113017272_hitting
imitating1238762imitating
kitting123214442_kitting
knitting13257022knitting
matting103620142_matting
milting103619122_milting
minting103020812_minting
misting103623382_misting
mitring103514142_mitring
opiating11410092opiating
pitting103618872_pitting
quitting18228832quitting
remitting122412622remitting
shitting123212662shitting
sitting83519632_sitting
slitting93012582slitting
smiting103014442smi_ting
smutting11278062smutting
spitting113012322spitting
twitting12307222twitting
vomiting1437732vomi_ting
witting113417062_witting
abetting1158293abetting
abutting1137003abutting
agisting1038243agisting
agitating1138863agitating
airting83616303_airting
aviating12311023aviating
baiting103918883bai_ting
batting104422273_batting
befitting15236623befitting
bemisting1438073bemisting
betting103921403_betting
biting95321823_bi_ting
bittings11339293_bittings
blatting114111653blatting
blitzing2035903blitzing
blotting113910433blotting
brittling1235543brittling
butting103519283_butting
catting103922643_catting
chatting142810143chatting
chitling142910663chitling
citing94220183_ci_ting
clotting113110643clotting
coadmitting1752613coadmitting
cogitating1447213cogitating
combating16310163combating
combatting1755143combatting
commuting16288443commuting
competing163712463competing
compting153013603com_pting
computing16309853computing
cuittling1234103cuittling
cutting103817493_cutting
dieting93616833_dieting
dinting93520553_dinting
dittoing1036263_dittoing
dominating1449403dominating
dotting93314483_dotting
dratting10389663dratting
drifting13338733drifting
duetting1047183duetting
editing9313133edi_ting
emoting10313563em_oting
emptying1634243emptying
evicting1437483evicting
eviting11511373evi_ting
existing1639073existing
exiting15311393exi_ting
fainting123312163fainting
faithing1537153faithing
fatting113818703_fatting
feinting123410833feinting
fetting113517873_fetting
fisting113818123_fisting
fittings12318203_fittings
flatting123511253flatting
flinting123412343flinting
flirting12319013flirting
fliting113514613fli_ting
foisting122910503foisting
foliating1339253foliating
fomenting1537233fomenting
formatting1644163formatting
formfitting2051893formfitting
fretting122711523fretting
gaiting93716583gai_ting
getting93316563_getting
gifting123810893_gifting
girting93113333_girting
gittin72910553_gittin_
glinting103210053glinting
glitzing1934973glitzing
glutting10247643glutting
grifting13299263grifting
gutting93415923_gutting
hatting113920233_hatting
heisting123411043heisting
hilting113316893_hilting
hinting113919223_hinting
histing113720373_histing
hoisting123610903hoisting
hotting113116523_hotting
hutting113016033_hutting
imputing1336853imputing
jetting153815343_jetting
jilting153211743_jilting
jointing16248613jointing
joisting16328503joisting
jotting152912773_jotting
jutting153313713_jutting
kilting123213853_kilting
kithing153411553_kithing
kiting114117093_ki_ting
kitling123313573_kitling
kittling1336063_kittling
knittings14273453knittings
knotting13236573knotting
letting83218533_letting
lifting113313273_lifting
lilting83515383_lilting
limiting1138813limiting
linting83820983_linting
listing84020593_listing
lotting82917753_lotting
malting103219083_malting
marting103325013_marting
masting104325823_masting
mating94832913_m_ating
mattin84416633_mattin_
mattings11369673_mattings
mattins93316143_mattins
meeting103314963_meeting
melting103317753_melting
meting94320593_m_eting
metring103215293_metring
miching152911803_miching
miffing16298403_miffing
miking134218463_mi_king
milding113615453_milding
milking143712763_milking
milling103223683_milling
miming114317263_mi_ming
mincing123314333_mincing
minding113317893_minding
mining94225453_mi_ning
minuting1139723_minuting
miring93723803_mi_ring
missing103619073_missing
mitering113015403_mitering
mitten83914093_mitten_
mittens9349883_mittens
mixing164713943_mi_xing
moating104218153_moating
moiling103417663moi_ling
molting103517173_molting
mooting103019363_mooting
motiving1437163motiving
mottling11197753mottling
moulting112710313moulting
mounting112711813mounting
mouthing142810243mouthing
munting103718773_munting
musting103221073_musting
mutating112211753_mutating
muting93921523_m_uting
netting84018763_netting
nominating1349503nominating
nutting83316233_nutting
obviating1545053obviating
oiling74925313o_i_ling
oinking123714713o_inking
omening10310093om_ening
omitted10347893omitt_ed
omitter9298503omitt_er
omitters10277653omitters
opining10311743opi_ning
opting94514403o__pting
orating83520323o_rating
orbiting1138153orbiting
orienting1038723orienting
oughting1335953oughting
ousting84021353o_usting
outfitting1465823outfitting
outhitting1446333outhitting
outing74128153o__uting
outring84021023o_utring
outsing83320463o_utsing
outsitting1147133outsitting
outwitting1445553outwitting
oxidating1845053oxidating
painting113614423painting
patting103722343_patting
permitting1546303permitting
petting103720953_petting
pithing134014053_pithing
pittings11349123_pittings
pitying132910243_pitying
platting114813033platting
plotting113011013plotting
pointing112813683pointing
positing11312303posi_ting
potting103720893_potting
printing113216083printing
putting103218573_putting
quieting18228463quieting
quilting18218713quilting
quirting18238383quirting
ratting83822363_ratting
reemitting1346633reemitting
refitting132811123refitting
reminting122315103reminting
resitting103414873resitting
retting83425883_retting
rifting113515003_rifting
rioting82716393_rioting
rotting82919683_rotting
rutting82718043_rutting
sainting93215733sainting
scatting113311813scatting
setting83621393_setting
shifting152910383shifting
shirting123213613shirting
shotting123012383shotting
shutting12309693shutting
sifting113014593_sifting
silting83320483_silting
siting74126623_si_ting
sittings9339733_sittings
skirting13289393skirting
skiting123812503ski_ting
slatting94014233slatting
slotting92612613slotting
smarting113212453smarting
smelting11339713smelting
smiling103915443smi_ling
smirking15277233smirking
smitten936693smitten_
something1545403something
sopiting11310763sopi_ting
spatting113111763spatting
spirting112913633spirting
spiting103917623spi_ting
splitting1236563splitting
spotting112812093spotting
stetting93410713stetting
stilting93312403stilting
stinting93415743stinting
stotting92811163stotting
submitting1544973submitting
suiting83419003sui_ting
swatting12309593swatting
swotting12268483swotting
tainting93613583tainting
tatting84019523_tatting
tilting83417103_tilting
tinting84620603_tinting
tithing113513893_tithing
titling83715793_titling
toiting83217093toi_ting
tomcatting1542433tomcatting
totting82816843_totting
trithing122811773trithing
trotting92510913trotting
tutting83515913_tutting
twisting12427813twisting
unfitting1336423unfitting
uniting8315823uni_ting
unmitring1245263unmitring
unwitting1335583unwitting
vatting113614853_vatting
vetting114216563_vetting
vittling1236143_vittling
waisting123615213waisting
waiting113618953wai_ting
wetting114117383_wetting
whetting1535973whetting
whisting15329543whisting
whiting143311303whi_ting
whittling1634383whittling
wilting113515913_wilting
wisting113519743_wisting
withing143814493_withing
witing103522823_wi_ting
witling113215813_witling
wittings12328733_wittings
wotting112913843_wotting
writhing15278673writhing
writing113713893wri_ting

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.453394461.4
2DLD Change Limit1461623017.40619735.6
3Display Results3013010.1232447.2
 (SQL Overall)1786913017.98222386.7
 
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.