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

329 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
hand8683370(None) 
and47244161_and
band76740901band
had77658761ha_d
haed86338581haed
hands95327381hands
handy125520871handy
hang85535541hang
hank115134131hank
hant75461581hant
hard85443501hard
hind85529751hind
land56337301land
rand55839561rand
sand55338461sand
wand85833871wand
ad311975032_a_d
add510132362_add
ahed89536252ahed
aid49269072_aid
aland65526412aland
an211879072_an_
ana39559822_ana
ands57833612_ands
ane37866942_ane
ani37751172_ani
ant37270782_ant
any68440482_any
bad67763152ba_d
bald76432902bald
ban58366832ban_
banda85223102banda
bands85233422bands
bandy114824182bandy
bane65250422bane
baned85436352baned
bang74836992bang
bani65334952bani
bank105835742bank
bans66555132bans
bard75648862bard
baud74928422baud
bawd105520842bawd
bend76435262bend
bhang115512922bhang
bind76234502bind
bland85320452bland
bond75334362bond
brand85124492brand
bund75530662bund
cad67456362ca_d
caid77837532caid
can57760132can_
candy115119822candy
cane66653112cane
caned85838092caned
canid85526342canid
cans65050842cans
cant66362022cant
card710245872card
chad105525502cha_d
chang115418562chang
chant105932692chant
chard116124742chard
dad58456162da_d
dan46859662dan_
dandy104416702dandy
dang65131532dang
dank95828232dank
dans56748142dans
eland65820392eland
end46834352_end
fad77452412fa_d
fan67158852fan_
fane75343562fane
fang85432542fang
fano75831682fano
fans76247362fans
fard85639062fard
fend84832972fend
find87532602find
fond86330952fond
fund85624982fund
gad57556652ga_d
gaed66031512gaed
gan48060122gan_
gane55145292gane
gang66031962gang
gaud67025432gaud
gland75217712gland
grand75122692grand
ha510259942ha__
haaf106227732haaf
haar77323492haar
habu97325482habu
hack135134542hack
hade85440192hade
haded105227622haded
hadj155818672hadj
hae67364002ha_e
haem95730982haem
haen76229452haen
haes77651022haes
haet75659502haet
haft105941842haft
hag77255742ha_g
hags86740842hags
hah910655222ha_h
haha107821062haha
hahs108333362hahs
haik115526982haik
hail74839062hail
haint85436322haint
hair76330142hair
haj138140602ha_j
haji148520182haji
hajj138312472hajj
hake115637842hake
haku116923892haku
hale76052832hale
haled95335822haled
half106238452half
halid94424972halid
hall75741162hall
halm95834972halm
halo76437322halo
halt76056302halt
ham86363282ha_m
hame97043132hame
hams96446132hams
hance105424152hance
handax1749582handax
handed114919982handed
hander104526432hander
handle104219292handle
hanged114222392hanged
hangs95726722hangs
hanked144220602hanked
hanks126226862hanks
hanky155418292hanky
hansa85416782hansa
hanse85722792hanse
hanted104124312hanted
hants86335402hants
hao67251122ha_o
hap87360052ha_p
haps96443462haps
hards96435652hards
hardy125622062hardy
hare76255732hare
hared95742182hared
hark115237392hark
harl75740002harl
harm95637792harm
harp96134282harp
hart76865772hart
has67372652ha_s
hash106936502hash
hasp96627292hasp
hast76259482hast
hat67289962ha_t
hate78450172hate
hated95734022hated
hath105933912hath
hats76858252hats
haul75530452haul
haunt85229132haunt
haut75949732haut
have106137072have
haw97153272ha_w
hawed126025422hawed
hawk145521152hawk
haws106439442haws
hay97358772ha_y
hayed125822012hayed
hays106138072hays
haze164833392haze
hazed185222202hazed
hazy1918119192hazy
head87137172head
heard95222752heard
heed86437602heed
held85330402held
hen67555272hen_
hens75642572hens
hent76656382hent
herd84933062herd
hid76248362h_id
hied85434042hied
hin67559562hin_
hinds96721472hinds
hins76447992hins
hint77455742hint
hoard94918312hoard
hod76852462h_od
hoed87837982hoed
hold86235062hold
hon67759382hon_
honda9414982honda
hone77549322hone
honed95332262honed
hong85833952hong
honk116931192honk
hons77350782hons
hood85132332hood
hound95016482hound
hued86925852hued
hun65844712hun_
hung86126352hung
hunh106323732hunh
hunk116029542hunk
huns76136932huns
hunt76445492hunt
hwan105716892hwan_
jane115031472jane
kana85928522kana
kane85133962kane
khan115819142khan_
khans124615172khans
kind96128552kind
lad48165702la_d
laid56439142laid
lands65426902lands
lane45153322lane
lang56637372lang
lank84734442lank
lard56742002lard
laud56527722laud
lend56233672lend
mad68958702ma_d
maid75537632maid
man57465852man_
mana65341942mana
mane65052012mane
maned86634092maned
mano66536792mano
mans66354532mans
many95731842many
maud75325392maud
maund85515442maund
mend75334022mend
mind75434362mind
nan37854872nan_
nana46632892nana
nans46139392nans
nard56634452nard
pad68057322pa_d
paid75737482paid
pan58466442pan_
panda85022612panda
pandy115021172pandy
pane64950282pane
paned85437182paned
pang75336282pang
pans65855722pans
pant66061252pant
pard76441322pard
pend75934532pend
pond75530492pond
qaid146023842qaid
rad47662002ra_d
raid55243072raid
ran38266612ran_
rands65930452rands
randy95022082randy
rang56939152rang
rani46640102rani
ranid66429332ranid
rank85135522rank
rant45864672rant
rend56136572rend
rind56535602rind
rynd86414102rynd
sad47459202sa_d
said55742112said
sands65228582sands
sandy94221132sandy
sane45954332sane
saned65636272saned
sang55441222sang
sank85236822sank
sans45153352sans
sard55344242sard
send55237292send
shad86230912sha_d
shandy134710032shandy
shank125422192shank
shard96125962shard
shend94719972shend
stand65923282stand
tad47959822ta_d
tan37167562tan_
tang56138662tang
tank85134012tank
tans46154812tans
tend56433772tend
than76128772than_
thane86122532thane
thank125817802thank
unhand10410382unhand
van66246322van_
vanda94515922vanda
vane75534682vane
vaned94622422vaned
vang84926032vang
vans76236722vans
vend86626422vend
viand9511072viand
wad77053892wa_d
wan66761932wan_
wands96425482wands
wane76344712wane
waned95831782waned
wank115632502wank
wans76452262wans
want76156162want
wany106432352wany
ward86542252ward
wend85330452wend
whang124813382whang
wind85533852wind
wynd116114462wynd
yald86920602yald
yang85626062yang
yank115423662yank
yard85633252yard
yaud87020082yaud
yond86122312yond
zany167316982zany

Search took 2 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 Filter178691298720.0762351197.4
2DLD Change Limit298723290.95331345.2
3Display Results3293290.0804112.5
 (SQL Overall)1786913291.109161128.0
 
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.