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

158 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
hmm10621899(None) 
ham86363281ham
hem86148731hem
him86247651him
hm78126731h_m
hum85542931hum
mm67826811_mm
umm711921261umm
ahem97225362ahem
aim57858212aim
am411875562_am
ama510853302ama
ami56646802ami
ammo85520132ammo
amp77541022amp
amu58237322amu
arm58449622arm
bam78560142bam
bum75342692bum
cam78058982cam
cham115532312cham
chum116318002chum
cum76440162cum
cwm106815082cwm
dam67457042dam
dim68146492dim
dom69752442dom
elm57531742elm
em49445152_em
eme55837182eme
emmy116013242emmy
ems56435492ems
emu55929982emu
fem86040732fem
gam67060062gam
gem66840222gem
gum67439532gum
gym95719062gym
ha510259942h_a
had77658762had
hae67364002hae
haem95730982haem
hag77255742hag
hah910655222hah
haj138140602haj
halm95834972halm
hame97043132hame
hammy155113432hammy
hams96446132hams
hao67251122hao
hap87360052hap
harm95637792harm
has67372652has
hat67289962hat
haw97153272haw
hay97358772hay
he58151952h_e
heh96039622heh
helm95530022helm
heme95034412heme
hemp115725622hemp
hems95534942hems
hen67555272hen
hep86644142hep
her66547812her
herm95636152herm
hes66654202hes
het67674312het
hew97642722hew
hex137436172hex
hey96741062hey
hi57947582h_i
hic86540562hic
hid76248362hid
hie67652702hie
hims95230972hims
hin67559562hin
hip86750432hip
his66359502his
hit66569192hit
ho510258272h_o
hob87550922hob
hod76852462hod
hoe67562722hoe
hog78049062hog
holm95628102holm
home98042442home
homo96126472homo
homy126623222homy
hon67759382hon
hop87554592hop
hos68364192hos
hot67776052hot
how97252432how
hoy97447912hoy
hub86437482hub
hue66642302hue
hug76037362hug
huh96432012huh
hump116228722hump
hums96831422hums
hun65844712hun
hup86437812hup
hut66457292hut
hymn12311312hymn
hyp117822462hyp
imam81718322imam
immy114611822immy
imp76626962imp
ism56322382ism
jam126942522jam
lam57666712lam
lum55542932lum
ma410060652_ma
me47748332_me
mem77943472mem
mho86624622mho
mi48249042_mi
mim76048412mim
mo49158482_mo
mom78853162mom
mu46737482_mu
mum76643612mum
mumm75718862mumm
my78125652_my
nam55953392nam
nim57142952nim
nom510450642nom
ohm86523012ohm
ohms95514032ohms
om48553002_om
oms56337512oms
pam77858392pam
pom78249912pom
ram56867272ram
rem56150042rem
rim56052272rim
rom59855632rom
rum56644642rum
sham96436352sham
shim95827842shim
shmo95318092shmo
sim56553132sim
som59153802som
sum56346012sum
tam58663422tam
them97427042them
tom514358052tom
um47338832_um
ump76130442ump
vim87437022vim
vum85428652vum
wham125321692wham
whim126220522whim
whom127018172whom
yam87448992yam
yom88043442yom
yum86132822yum

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.0602978183.3
2DLD Change Limit140841580.37637457.4
3Display Results1581580.0305266.7
 (SQL Overall)1786911580.466383457.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.