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

350 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
hoer7653398(None) 
doer57734701doer
goer56827101goer
her66547811h_er
hoar76729161hoar
hoe67562721hoe_
hoed87837981hoed
hoers85724921hoers
hoes75755731hoes
homer105828451homer
honer85332091honer
hoper105829141hoper
hoser811529761hoser
hour75827311hour
hover115524131hover
shoer84722151shoer
ager55935842ager
aper66336232aper
aver75931882aver
beer65635992beer
bier65531832bier
boar66134292boar
boner75133082boner
boor66130682boor
bore66051332bore
borer75131272borer
bower107328182bower
boxer145016522boxer
cheer105420382cheer
choir105313592choir
choker154314372choker
choler113717152choler
chore105126762chore
coder86134212coder
coed77140542coed
coir66327242coir
comer95832692comer
cooer74831012cooer
coper95336092coper
cor59960942co_r
core67263112core
corer75538872corer
cover105430772cover
cower104531772cower
coyer105222842coyer
deer56739022deer
doe47361952doe_
doers65225712doers
does56554472does
door56928512door
doper86128392doper
dor47253922do_r
dore56353302dore
dorr56627722dorr
doser66228562doser
doter65428622doter
dour56330432dour
dower95027702dower
dozer158419272dozer
dyer85522112dyer
echoer114011102echoer
eger55923562eger
er28345142__er
ever77027692ever
ewer77523982ewer
eyer76127282eyer
fer66646122_fer
foe66350812foe_
foes76543442foes
for66952072fo_r
fore78351472fore
four76226862four
foyer116416552foyer
goers65520252goers
goes55644092goes
gofer94814282gofer
gomer85220652gomer
goner66025162goner
gor47848262go_r
gore55744962gore
haar77323492haar
hae67364002hae_
haed86338582haed
haem95730982haem
haen76229452haen
haes77651022haes
haet75659502haet
hair76330142hair
haler85033522haler
hare76255732hare
hater85034752hater
haver115124462haver
hayer114620242hayer
hazer174820232hazer
he58151952h_e_
hear76143882hear
heder95623632heder
heed86437602heed
heel75034222heel
heh96039622h_eh
heir77523802heir
hem86148732h_em
hen67555272h_en
hep86644142h_ep
herb94730962h_erb
herd84933062h_erd
here76447102h_ere
herl75834552h_erl
herm95636152h_erm
hern76134892h_ern
hero74635782h_ero
hers75844872h_ers
hes66654202h_es
het67674312h_et
hew97642722h_ew
hewer115719932hewer
hex137436172h_ex
hexer155116682hexer
hey96741062h_ey
hider95024082hider
hie67652702hie_
hied85434042hied
hies74842832hies
hiker125119392hiker
hire75538962hire
hirer85423122hirer
ho510258272ho__
hoard94918312hoard
hoars85925542hoars
hoary114516762hoary
hoax147718292hoax
hoaxer16348562hoaxer
hob87550922ho_b
hobber134114632hobber
hobo97026082hobo
hobs97038982hobs
hock136031302hock
hocker155118562hocker
hod76852462ho_d
hods87239862hods
hog78049062ho_g
hogg96617532hogg
hogger114615082hogger
hogs87139662hogs
hoke115935932hoke
hoked135326992hoked
hokes126231642hokes
hokey155422182hokey
hokier134214032hokier
hold86235062hold
holder104619652holder
hole77553392hole
holed95634132holed
holes84748652holes
holey115626902holey
holier94921622holier
holk116027942holk
holler93520612holler
holm95628102holm
holp95727552holp
hols76946292hols
holt77852582holt
holy106333432holy
home98042442home
homed115425422homed
homers114821972homers
homes106938812homes
homey135924842homey
homier116416992homier
homo96126472homo
homy126623222homy
hon67759382ho_n
hone77549322hone
honed95332262honed
honers94324972honers
hones88144492hones
honey115629912honey
hong85833952hong
honk116931192honk
honker134117462honker
honor85718622honor
hons77350782hons
hood85132332hood
hooey114926602hooey
hoof106036582hoof
hoofer124014952hoofer
hook116133282hook
hooker134820172hooker
hoop96129982hoop
hooper114518312hooper
hoot75752092hoot
hooter94123922hooter
hoover124314432hoover
hop87554592ho_p
hope96639672hope
hoped115628182hoped
hopers114222972hopers
hopes105835642hopes
hopper134218482hopper
hops97942632hops
hora76136552hora
horn76735612horn
hos68364192ho_s
hose76547242hose
hosed95830982hosed
hosel86024812hosel
hosen85623882hosen
hosers95223952hosers
hoses85443172hoses
hosey116127022hosey
hosier94219612hosier
host77852832host
hot67776052ho_t
hotel85520742hotel
hots78349322hots
hotter94720072hotter
houri85915232houri
hours85422382hours
houser95322282houser
hove107132222hove
hovel115017682hovel
hovers124320252hovers
how97252432ho_w
howe106734102howe
howes114730262howes
howf136127202howf
howk145221962howk
howl107625692howl
howler123514312howler
hows106345602hows
hoy97447912ho_y
hoya107418372hoya
hoys107733932hoys
hue66642302hue_
hued86925852hued
hues75235232hues
huger94914872huger
hyper135213902hyper
jeer115426462jeer
joe106642352joe_
joes116635892joes
joey145719332joey
joker165715892joker
kier86526802kier
koel84519942koel
kor76538892ko_r
kore85834162kore
leer46239352leer
lier45942462lier
loner55431042loner
loper75129232loper
lore45850352lore
loser54728672loser
lour45430682lour
lover85526452lover
lower85830412lower
moor66628552moor
moper94925922moper
mor56855002mo_r
more67154522more
mover104220862mover
mower104523452mower
noel45226552noel
noes45845392noes
noir46722432noir
nor38048822no_r
noter55025642noter
oar37057952_oar
oe28473062_oe_
oes35866192_oes
ohed87825182ohed
omer67028392omer
or27354732_o_r
ore36661832_ore
our36042892_our
over77227342over
oyer75927652oyer
peer66238352peer
per56353092_per
pier66035292pier
poem86225772poem
poet65552902poet
poker115122882poker
poler74431792poler
poor65630222poor
pore66451262pore
poser75128772poser
pour611527472pour
power105325952power
roar46328572roar
roe36861072roe_
roes45954132roes
roger64521412roger
roper75431912roper
rover85527372rover
rower85430492rower
ruer46127562ruer
seer45547042seer
ser36752402_ser
sheer84726892sheer
shier85428942shier
shoe75933432shoe_
shoed95723002shoed
shoers94518322shoers
shoes85429652shoes
shore85432642shore
shover124515982shover
shower124315102shower
shyer114714782shyer
soar46838672soar
sober74822402sober
sore47059532sore
sorer56236572sorer
sour45935892sour
sower85229312sower
suer45334032suer
tier44936142tier
toe310166852toe_
toea46732332toea
toed56137042toed
toes46956442toes
toker95924912toker
toner55336242toner
toper75231022toper
tor39261682to_r
tore47359322tore
torr45630902torr
toter55932132toter
tour45530372tour
tower85729202tower
toyer84521552toyer
tyer75323392tyer
user45023002user
veer76229572veer
vier75428152vier
voe67739052voe_
voes75432822voes
vomer105517382vomer
voter85121052voter
vower115220792vower
weer75535092weer
whore116018042whore
woe66651242woe_
woes76440662woes
wooer84316692wooer
wore77144672wore
yore76335942yore
your78623432your
zoea137118422zoea
zoner144520342zoner

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.0632836365.1
2DLD Change Limit298723500.86034734.9
3Display Results3503500.0933763.4
 (SQL Overall)1786913501.016175877.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.