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

296 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
hoers8572492(None) 
doers65225711doers
goers65520251goers
hers75844871h_ers
hoars85925551hoars
hoer76533981hoer_
hoes75755731hoe_s
homers114821971homers
honers94324971honers
hopers114222971hopers
hosers95223961hosers
hours85422391hours
hovers124320251hovers
shoers94518331shoers
agers65027852agers
apers76629132apers
avers85127312avers
beers75628392beers
biers76225222biers
boars75229602boars
boners84825432boners
boors74325012boors
borers85122682borers
bores76448252bores
bowers115523702bowers
boxers155013482boxers
cheers114518912cheers
choirs114911882choirs
chokers164311522chokers
cholers124215202cholers
chores114828022chores
coders95426982coders
coeds85920162coeds
coirs75221052coirs
comers105328082comers
cooers84324562cooers
copers104629842copers
corers85231072corers
cores76361852cores
cors66656442co_rs
covers114627962covers
cowers114625532cowers
deers64930522deers
doer57734702doer_
does56554472doe_s
doors65022132doors
dopers95522482dopers
dorrs65520592dorrs
dors56747602do_rs
dosers75723632dosers
doters74423912doters
dowers104523292dowers
dozers164815422dozers
dyers96617132dyers
echoers12459692echoers
egers65120372egers
ers36046282__ers
ewers86018822ewers
eyers86521332eyers
foes76543442foe_s
fores85847102fores
fours85521492fours
foyers125413132foyers
goer56827102goer_
goes55644092goe_s
gofers104711512gofers
gomers94116882gomers
goners74420172goners
gores65740372gores
haars85620472haars
haems105517012haems
haeres94017032haeres
haes77651022hae_s
haets86525122haets
hairs86225172hairs
halers94926912halers
hares86255542hares
haters94930402haters
havers124721482havers
hayers124415942hayers
hazers184615952hazers
hears86737372hears
heders104119762heders
heeds95420422heeds
heels85625532heels
hehs106723962h_ehs
heirs85618562heirs
hems95534942h_ems
hens75642572h_ens
her66547812h_er_
herb94730962h_erb
herbs105520502h_erbs
herd84933062h_erd
herds96424682h_erds
here76447102h_ere
heres86245902h_eres
herl75834552h_erl
herls85226432h_erls
herm95636152h_erm
herms105626432h_erms
hern76134892h_ern
herns84825582h_erns
hero74635782h_ero
heros84930862h_eros
hes66654202h_e_s
hets75547202h_ets
hewers123715272hewers
hews105631572h_ews
hexers165612752hexers
hiders104919652hiders
hies74842832hie_s
hikers135014352hikers
hirers94518062hirers
hires86134342hires
hoar76729162hoar_
hoard94918312hoard
hoards104912622hoards
hoarse94411322hoarse
hoary114516762hoary
hoaxers17327132hoaxers
hobbers143512342hobbers
hobos106321352hobos
hobs97038982ho_bs
hockers163915912hockers
hocks144925492hocks
hocus104715202hocus
hods87239862ho_ds
hoe67562722hoe__
hoed87837982hoe_d
hoggers124512482hoggers
hoggs107212462hoggs
hogs87139662ho_gs
hokes126231642hokes
holders113715902holders
holds94623242holds
holes84748652holes
holks124720562holks
hollers103818232hollers
holms105117802holms
hols76946292ho_ls
holts85627912holts
homer105828452homer_
homes106938812homes
homeys145012872homeys
homos105921782homos
honer85332092honer_
hones88144492hones
honeys124016082honeys
hongs95126202hongs
honkers143315232honkers
honks125124522honks
honors94816792honors
hons77350782ho_ns
hoods95124082hoods
hooeys125512312hooeys
hoofers134513322hoofers
hoofs115721042hoofs
hookers144916512hookers
hooks125027122hooks
hoopers123616482hoopers
hoops105621072hoops
hooters104520472hooters
hoots84830252hoots
hoovers134312702hoovers
hoper105829142hoper_
hopes105835642hopes
hoppers143115142hoppers
hops97942632ho_ps
hora76136562ho_ra
horas86333102horas
horn76735612ho_rn
horns86125332horns
horse86132652ho_rse
horst85833512ho_rst
horsy116318392ho_rsy
hos68364192ho__s
hosels94218602hosels
hoser811529762hoser_
hoses85443172hoses
hoseys124614002hoseys
hosiers104212642hosiers
hosts85526702hosts
hotels94515512hotels
hots78349332ho_ts
hour75827312hour_
houri85915252houri
houris94514582houris
housers104717812housers
hovels125413332hovels
hover115524132hover_
howes114730262howes
howfs144814502howfs
howks155016852howks
howlers133312352howlers
howls116219222howls
hows106345602ho_ws
hoyas115016162hoyas
hoys107733932ho_ys
hues75235232hue_s
hypers144811912hypers
jeers124818132jeers
joes116635892joe_s
joeys15518042joeys
jokers175511192jokers
kiers95320092kiers
koels94613902koels
kors85933012ko_rs
leers54828982leers
liers55130402liers
loess55714702loess
loners64225812loners
lopers84424142lopers
lores55045402lores
losers65123582losers
lours55125292lours
lovers94223432lovers
lowers94624922lowers
moors74923142moors
mopers104220372mopers
mores76249642mores
mors65950062mo_rs
movers115117192movers
mowers113219402mowers
noels56418702noels
noes45845392noe_s
noirs55615462noirs
noters64021002noters
oars46846032_oars
oes35866192_oe_s
omers76923192omers
ores46056682_ores
ors35750112_o_rs
ours47237562_ours
overs85224792overs
oyers87620882oyers
peers75130272peers
piers75926332piers
poems95715552poems
poets76024442poets
pokers124617922pokers
polers84225642polers
pores75849032pores
posers84223972posers
pours74623182pours
powers113822322powers
roars55622242roars
roes45954142roe_s
rogers74517912rogers
ropers84325902ropers
rovers95423522rovers
rowers94924572rowers
ruers515019412ruers
seers55136382seers
sers45746652_sers
sheers94322402sheers
shiers94921752shiers
shoer84722162shoer_
shoes85429662shoe_s
shores94830412shores
shovers134613002shovers
showers134612682showers
shyers124712202shyers
soars54732512soars
sobers85218862sobers
sores55454282sores
sours55230502sours
sowers94923442sowers
suers55128482suers
tiers55526522tiers
toeas55726422toeas
toes46956442toe_s
tokers104818892tokers
toners64128002toners
topers85025322topers
tores55352672tores
torrs53923562torrs
tors46157382to_rs
toters65026362toters
tours55325892tours
towers94423672towers
toyers95516332toyers
tyers86220052tyers
users55817572users
veers84521362veers
viers85621952viers
voes75432822voe_s
vomers115614942vomers
voters95017442voters
vowers124317182vowers
whores125617102whores
woes76440662woe_s
wooers93712442wooers
yores85031322yores
yours85217882yours
zoeas145815612zoeas
zoners155115992zoners

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 Filter178691538000.313570897.8
2DLD Change Limit538002961.46636698.5
3Display Results2962960.0803700.0
 (SQL Overall)1786912961.85996122.1
 
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.