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 “omit” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

143 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
omit6533737(None) 
emit65438421emit
obit66837081obit
omits75018261omits
smit65138411smit
vomit102622571vomit
adit56443652adit
admit8319492admit
ait38093902_ait
alit46155692alit
ambit94223712ambit
ami56646812ami_
amia66836902amia
amid77036352amid
amie66339852amie
amin66042252amin
amir65129752amir
amis66445322amis
amity10416092amity
bait66556002bait
bit57070902_bit
brit66350152brit
chit96937462chit
comet95946072comet
comfit133112422comfit
comic114721812comic
comity13312712comity
comix163513202comix
commit124016702commit
compt116328222compt
crit65743712crit
demit84832302demit
dit47071332_dit
doit56347852doit
domic104317242domic
duit56241582duit
edit54934862edit
emic86422752emic
emir65918702emir
emits75421472emits
exit114428672exit
fit66365452_fit
flit76539272flit
fomite113314072fomite
frit77044472frit
gait56150192gait
git46266052_git
grit55247242grit
hit66569192_hit
homie104622532homie
imid76122292imid
it28455682__it
kit78559872_kit
knit85728142knit
limit73126342limit
lit39377312_lit
mat58083942_mat
met56072432_met
mi48249052_mi_
mib76946122_mib
mic77647642_mic
mid67354462_mid
mig65646082_mig
mil55752112_mil
milt65455812_milt
mim76048422_mim
mint66758062_mint
mir57046772_mir
mis58162622_mis
mist66154532_mist
mite66249412_mite
mitt66145492_mitt
mity95528212_mity
mix126138182_mix
mixt136831922_mixt
moat66352032moat
moil65534092moil
moist76033582moist
molt66356162molt
momi87524482momi_
moot67653622moot
mort66758832mort
most66554202most
mot57279422_mot
mott66648442mott
mut58357182_mut
nit37065942_nit
oast47156322oast
oat39888262o_at
obi57127732obi_
obia67923112obia
obis66226842obis
obits74617552obits
odic74920572odic
odist6421912odist
oft67744062o_ft
ohia75719362ohia
ohmic1237832ohmic
oi29061482o_i_
oil37452052o_il
olio46829672olio
om48553002om__
omen66828182omen
omer67028392omer
oms56337512om_s
oot311274692o_ot
opt57545542o_pt
orbit73622062orbit
ort39465232o_rt
osmic939912osmic
otic66624822otic
oust46747442oust
out38072152o_ut
oxid12815482oxid
oxim131114052oxim
pit56471922_pit
posit75833332posit
quit136136512quit
remit75737222remit
shit76745942shit
sit35877752_sit
skit85437532skit
slit46250102slit
smite75224872smite
smith107818052smith
smut66629782smut
snit46342472snit
somite84519372somite
spit65545082spit
suit45649872suit
tit36771052_tit
toit46353062toit
tomtit8413852tomtit
twit76329062twit
unit45140072unit
vomito11238032vomito
vomits112610922vomits
wait75553692wait
whit104834172whit
wit66563772_wit
writ75537912writ
yomim12510082yomim
zit126049992_zit

Search took 1 second 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 Filter178691298720.0602978183.3
2DLD Change Limit298721430.86034734.9
3Display Results1431430.0334333.3
 (SQL Overall)1786911430.953187503.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.