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

203 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
ohm8652301(None) 
hm78126731_hm
oh57447001oh_
ohms95514031ohms
oho66534381oho
ohs66232311ohs
om48553001o_m
abohm1247972abohm
ah513868792ah_
aha611246642aha
ahem97225362ahem
ahi68040232ahi
ahs68644822ahs
aim57858212aim
am411875562_am
arm58449622arm
bam78560142bam
boho96923322boho
boom87435672boom
bum75342692bum
cam78058982cam
cham115532312cham
chi86228652chi
chum116318002chum
coho97524492coho
corm85735372corm
cum76440162cum
cwm106815082cwm
dam67457042dam
dim68146492dim
dom69752442dom
doom76430072doom
dorm76834632dorm
doum76226672doum
eh58339962eh_
elm57531742elm
em49445152_em
fem86040732fem
foam97127172foam
foh98135892foh_
fohn106116552fohn
form95836872form
gam67060062gam
gem66840222gem
ghi77019882ghi
gorm75529392gorm
gum67439532gum
gym95719062gym
ha510259942_ha
ham86363282ham
he58151952_he
hem86148732hem
hi57947582_hi
him86247662him
hmm106218992hmm
ho510258272_ho
hob87550922hob
hod76852462hod
hoe67562722hoe
hog78049062hog
holm95628112holm
home98042442home
homo96126472homo
homy126623222homy
hon67759382hon
hop87554592hop
hos68364192hos
hot67776062hot
how97252432how
hoy97447912hoy
hum85542932hum
ism56322382ism
jam126942522jam
john145512902john
khi106318302khi
kohl113911712kohl
lam57666712lam
loam65630482loam
loom67035052loom
lum55542932lum
mem77943472mem
mho86624622mho
mim76048422mim
mm67826812_mm
mom78853162mom
mum76643612mum
nam55953392nam
nim57142952nim
noh66640642noh_
nom510450642nom
norm66429812norm
oaf65952882oaf
oak76238652oak
oar37057952oar
oat39888262oat
oba57531552oba
obe56638642obe
obi57127732obi
oca56731732oca
od39255242o_d
oda48133042oda
odd57725452odd
ode47446582ode
ods47546212ods
oe28473062o_e
oes35866192oes
of58247772o_f
off96331632off
oft67744062oft
ogam75120032ogam
ogham1138252ogham
ohed87825182ohed
ohia75719362ohia
ohmic1237832ohmic
oi29061482o_i
oil37452052oil
oka76926802oka
oke75839482oke
old47033462old
ole37155212ole
oms56337512oms
on28057182o_n
one37050912one
ono36838032ono
ons36148512ons
ooh67637092ooh
oohs75220692oohs
oot311274692oot
op45850162o_p
ope56845242ope
ops56641252ops
opt57545542opt
or27354732o_r
ora37250832ora
orb55736862orb
orc57034922orc
ore36661832ore
ors35750112ors
ort39465232ort
os211359882o_s
ose38147342ose
oud47439072oud
our36042892our
out38072152out
ova66823792ova
ovum92310172ovum
ow58950172o_w
owe67041032owe
owl66228972owl
own66429702own
ox98242382o_x
oxim131114052oxim
oxo107322962oxo
oxy136320982oxy
oy58950132o_y
pam77858392pam
phi86524202phi
pht86030522pht
poem86225772poem
poh86740532poh_
pom78249912pom
ram56867272ram
rem56150042rem
rho65924832rho
rim56052272rim
roam67132412roam
rom59855632rom
room66235082room
rum56644642rum
sh56828522sh_
sha69837782sha
sham96436362sham
she66837692she
shh97121072shh
shim95827862shim
shmo95318102shmo
shy96728192shy
sim56553142sim
som59153812som
sum56346012sum
tam58663422tam
the67436052the
them97427042them
tho67433962tho
thy97022912thy
tom514358052tom
toom66532932toom
uh57429852uh_
um47338832_um
umm711921262umm
vim87437022vim
vum85428652vum
wha96422072wha
wham125321692wham
whim126220532whim
who95526772who
whom127018182whom
why126920012why
worm96129482worm
yam87448992yam
yom88043442yom
yum86132822yum
zoom156722102zoom

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 Filter178691140840.0632836365.1
2DLD Change Limit140842030.39036112.8
3Display Results2032030.0464413.0
 (SQL Overall)1786912030.499358098.2
 
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.