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

225 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
homer10582845(None) 
comer95832691comer
gomer85220651gomer
hoer76533981ho_er
home98042441home_
homed115425421homed
homers114821971homers
homes106938811homes
homey135924841homey
homier116416991homier
honer85332091honer
hoper105829141hoper
hoser811529761hoser
hover115524131hover
omer67028391_omer
vomer105517381vomer
aimer75926822aimer
armer76924442armer
bomber125014652bomber
boner75133082boner
boomer104618512boomer
borer75131272borer
bower107328182bower
boxer145016522boxer
chimer135517202chimer
choker154314372choker
choler113717152choler
chomper163810072chomper
coder86134222coder
comber125118502comber
come87547702come_
comers105328082comers
comes97246992comes
comet95946072comet
cooer74831012cooer
coper95336092coper
corer75538872corer
cover105430772cover
cower104531772cower
coyer105222842coyer
dimer85625602dimer
doer57734702do_er
dome77240732dome_
domed95423262domed
domes85735562domes
doper86128392doper
dormer94415902dormer
doser66228562doser
doter65428622doter
dower95027702dower
dozer158419272dozer
emmer94314462emmer
foamer114714312foamer
former114221402former
foyer116416552foyer
fumer105918232fumer
gamer84928942gamer
goer56827102go_er
gofer94814282gofer
gomers94116882gomers
goner66025162goner
haler85033522haler
hame97043132hame_
hames106138702hames
hammer138120032hammer
hamper134518652hamper
harmer114719552harmer
hater85034752hater
haver115124462haver
hayer114620242hayer
hazer174820232hazer
heder95623642heder
heme95034412heme_
hemes105031082hemes
hemmer134112642hemmer
her66547812h__er
hewer115719932hewer
hexer155116682hexer
hider95024082hider
hiker125119392hiker
hirer85423122hirer
hoar76729162ho_ar
hoaxer16348562hoaxer
hobber134114632hobber
hocker155118562hocker
hoe67562722ho_e_
hoed87837982ho_ed
hoers85724922ho_ers
hoes75755732ho_es
hogger114615082hogger
hoke115935932hoke_
hoked135326992hoked
hokes126231642hokes
hokey155422182hokey
hokier134214032hokier
holder104619652holder
hole77553392hole_
holed95634132holed
holes84748652holes
holey115626902holey
holier94921622holier
holler93520612holler
homager13107852homager
hombre13309302hombre
homely145313172homely
homered133212712homered
homeric14312212homeric
homeys145012872homeys
homie104622532homie
homies114524722homies
homo96126472hom_o
homos105921782homos
homy126623222hom_y
hone77549322hone_
honed95332262honed
honers94324972honers
hones88144492hones
honey115629912honey
honker134117462honker
honor85718622honor
hooey114926602hooey
hoofer124014952hoofer
hooker134820172hooker
hooper114518312hooper
hooter94123932hooter
hoover124314432hoover
hope96639672hope_
hoped115628182hoped
hopers114222972hopers
hopes105835642hopes
hopper134218482hopper
hose76547242hose_
hosed95830982hosed
hosel86024812hosel
hosen85623882hosen
hosers95223962hosers
hoses85443172hoses
hosey116127022hosey
hosier94219612hosier
hotel85520752hotel
hotter94720082hotter
hour75827312ho_ur
houser95322282houser
hove107132222hove_
hovel115017682hovel
hovers124320252hovers
howe106734102howe_
howes114730262howes
howler123514312howler
huger94914872huger
humeri1138522humeri
hummer133615272hummer
humor101110512humor
humper134115882humper
hymen13311042hymen
hyper135213902hyper
isomer8310152isomer
joker165715892joker
lamer75233702lamer
loner55431042loner
loper75129232loper
loser54728672loser
lover85526452lover
lower85830412lower
mimer94825762mimer
mome85239352mome_
momes95134472momes
momser104011412momser
momzer19327552momzer
moper94925922moper
mover104220862mover
mower104523452mower
namer75622102namer
nome66038422nome_
nomen75621622nomen
nomes74933122nomes
noter55025642noter
omber95316442_omber
omen66828182_omen
omers76923192_omers
ormer75218372ormer
over77227342_over
oyer75927652_oyer
poker115122882poker
poler74431792poler
pome85636692pome_
pomes94833932pomes
poser75128772poser
power105325952power
rhymer14387082rhymer
rimer75429242rimer
roamer84715162roamer
roger64521412roger
romeo73719702romeo
romper104213682romper
roomer84718632roomer
roper75431912roper
rover85527372rover
rower85430492rower
shoer84722162sho_er
shover124515992shover
shower124315112shower
sober74822412sober
somber103714002somber
some66040382some_
sorer56236592sorer
sower85229312sower
tamer75230102tamer
timer75626042timer
toker95924912toker
tome67543192tome_
tomes76037382tomes
toner55336242toner
toper75231022toper
toter55932132toter
tower85729202tower
toyer84521552toyer
vomers115614942vomers
voter85121052voter
vower115220792vower
women104619252women
womera11137592womera
wooer84316692wooer
wormer114514912wormer
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 Filter178691538000.326548131.9
2DLD Change Limit538002251.55034709.7
3Display Results2252250.0762960.5
 (SQL Overall)1786912251.95291542.5
 
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.