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

253 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
hoper10582914(None) 
coper95336091coper
doper86128391doper
hoer76533981ho_er
homer105828451homer
honer85332091honer
hooper114518311hooper
hope96639671hope_
hoped115628181hoped
hopers114222971hopers
hopes105835641hopes
hopper134218481hopper
hoser811529761hoser
hover115524131hover
hyper135213901hyper
loper75129231loper
moper94925921moper
roper75431911roper
toper75231021toper
aper66336232_aper
asper75520432asper
boner75133082boner
bopper123813832bopper
borer75131272borer
bower107328182bower
boxer145016522boxer
caper94831622caper
choker154314372choker
choler113717152choler
chomper163810072chomper
chopper163611892chopper
coder86134222coder
comer95832692comer
cooer74831012cooer
cooper104221122cooper
cope86847382cope_
coped105036842coped
copen94826432copen
copers104629842copers
copes97747102copes
copier103722892copier
copper124321892copper
copter109822012copter
corer75538872corer
cover105430772cover
cower104531772cower
coyer105222842coyer
doer57734702do_er
dope76038892dope_
doped95326712doped
dopers95522482dopers
dopes84935042dopes
dopey116020352dopey
dopier93515922dopier
dorper94314572dorper
doser66228562doser
doter65428622doter
dower95027702dower
dozer158419272dozer
duper85519002duper
eloper85414152eloper
foyer116416552foyer
gaper86125122gaper
goer56827102go_er
gofer94814282gofer
gomer85220652gomer
goner66025162goner
gopher1239182gopher
groper94517252groper
haler85033522haler
hamper134518652hamper
harper115018402harper
hater85034752hater
haver115124462haver
hayer114620242hayer
hazer174820232hazer
heaper114119522heaper
heder95623642heder
helper114313092helper
hepper133412662hepper
her66547812h__er
hewer115719932hewer
hexer155116682hexer
hider95024082hider
hiker125119392hiker
hipper133818022hipper
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
holpen11299412holpen
home98042442home_
homed115425422homed
homers114821972homers
homes106938812homes
homey135924842homey
homier116416992homier
hone77549322hone_
honed95332262honed
honers94324972honers
hones88144492hones
honey115629912honey
honker134117462honker
honor85718622honor
hooey114926602hooey
hoofer124014952hoofer
hooker134820172hooker
hooped125518182hooped
hoopers123616482hoopers
hooter94123932hooter
hoover124314432hoover
hop87554592hop__
hopped144318112hopped
hoppers143115142hoppers
hoppier143110702hoppier
hoppy154912352hoppy
hops97942632hop_s
hose76547242hose_
hosed95830982hosed
hosel86024812hosel
hosen85623882hosen
hosers95223962hosers
hoses85443172hoses
hosey116127022hosey
hosier94219612hosier
hotel85520752hotel
hotter94720082hotter
hour75827312ho_ur
houser95322282houser
hove107132222hove_
hovel115017682hovel
hovers124320252hovers
howe106734102howe_
howes114730262howes
howler123514312howler
huger94914872huger
humper134115882humper
hype125519812hype_
hyped145313332hyped
hypers144811912hypers
hypes135818672hypes
japer146218882japer
joker165715892joker
kopek1037812kopek
leper74820742leper
loner55431042loner
looper83817112looper
lope65941922lope_
loped85128332loped
lopers84424142lopers
lopes76437342lopes
lopper103717202lopper
loser54728672loser
lover85526452lover
lower85830412lower
mope86838042mope_
moped105424732moped
mopers104220372mopers
mopery135210972mopery
mopes95134982mopes
mopey124821822mopey
mopier103914782mopier
mopper126215002mopper
mover104220862mover
mower104523452mower
nope65934192nope_
noter55025642noter
omer67028392_omer
ope56845242_ope_
oped76230152_oped
open66427002_open
opera7313572_opera
opes65942612_opes
over77227342_over
oyer75927652_oyer
paper95128662paper
per56353092__per
piper96523192piper
poker115122882poker
poler74431792poler
pope85535612pope_
popery134511702popery
popes95933812popes
popper93615962popper
poser75128772poser
power105325952power
proper104319952proper
raper74932752raper
riper74328402riper
roger64521412roger
romper104213682romper
rope65542912rope_
roped84630802roped
ropers84325902ropers
ropery114313872ropery
ropes75940062ropes
ropey106021872ropey
ropier84118802ropier
rover85527372rover
rower85430492rower
shaper114119932shaper
shoer84722162sho_er
shopper143312632shopper
shover124515992shover
shower124315112shower
sloper84615912sloper
soaper84517872soaper
sober74822412sober
sopor74016492sopor
sorer56236592sorer
sower85229312sower
stoper84320102stoper
super74924482super
taper74829772taper
toker95924912toker
toner55336242toner
tope65946382tope_
toped85631312toped
topee76029952topee
topers85025322topers
topes76941762topes
topper103817602topper
toter55932132toter
tower85729202tower
toyer84521552toyer
upper93714262upper
viper105017302viper
vomer105517382vomer
voter85121052voter
vower115220792vower
whooper15297152whooper
whopper17328502whopper
wiper105421292wiper
wooer84316692wooer
zoner144520342zoner

Search took 4 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.606294869.6
2DLD Change Limit538002532.78319331.7
3Display Results2532530.1401807.1
 (SQL Overall)1786912533.52950635.0
 
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.