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

218 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
hebes10552167(None) 
hebe96424701hebe_
hemes105031081hemes
heres86245901heres
hexes155123041hexes
thebes115914491thebes
abbes96723532abbes
aedes64625152aedes
babes95834112babes
bees65453382be_es
benes75536232benes
bes56557432__bes
beses75830722beses
cedes84927332cedes
cees65941592ce_es
cepes94424462cepes
ceres75540012ceres
cetes75731102cetes
chebec1536962chebec
chebecs1635012chebecs
cubes95028162cubes
debs76530242deb_s
debts86418372debts
debyes1238102debyes
dees56356632de_es
dekes105224452dekes
deles65139252deles
demes86032692demes
denes65639722denes
dexes135224512dexes
ebbs82411992_ebbs
ekes86726602_ekes
emes65434662_emes
ephebes1436152ephebes
eses45336102_eses
eves76230462_eves
ewes76328702_ewes
exes116530812_exes
eyes75837882_eyes
feces105625362feces
feebs106112682feebs
fees76450602fe_es
femes105626222femes
feres86038182feres
fetes85630142fetes
fezes175220022fezes
gees55647882ge_es
genes65133092genes
ghees95215552ghe_es
gibes84422522gibes
glebes95512242glebes
grebes93813612grebes
gybes115012722gybes
habus106317142habus
hades96035112hades
haeres94017032haeres
haes77651022h_aes
hajes155420942hajes
hakes126034302hakes
hales85449842hales
hames106138702hames
hares86255542hares
hates86742572hates
haves116034872haves
hazes174928322hazes
heads95127112heads
heals85733462heals
heaps105223222heaps
hears86737372hears
heats85838402heats
heaves124120302heaves
hecks145220652hecks
heder95623642heder
heders104119762heders
hedges115016262hedges
heed86437602he_ed
heeds95420422heeds
heel75034222he_el
heels85625532heels
heezes184211642heezes
hefts116218152hefts
hehs106723962he_hs
heils85222192heils
heirs85618562heirs
hells85032042hells
helms105619462helms
helos84928062helos
helps105219342helps
helves124316062helves
heme95034412heme_
hemps126917332hemps
hems95534942he_ms
henges104516462henges
hens75642572he_ns
hents87330742hents
herbed123513452herbed
herbs105520502herbs
herds96424682herds
here76447102here_
heresy125011232heresy
herls85226432herls
herms105626432herms
herns84825582herns
heroes94923832heroes
heros84930862heros
herpes115517322herpes
hers75844872he_rs
hes66654202h__es
hests85829932hests
heths116317782heths
hets75547202he_ts
hewed125619432hewed
hewer115719932hewer
hewers123715272hewers
hews105631572he_ws
hexed165615762hexed
hexer155116682hexer
hexers165612752hexers
hides95129432hides
hies74842842h_ies
hikes125426982hikes
hires86134342hires
hives116925512hives
hoboes114717452hoboes
hobos106321352hobos
hobs97038982hob_s
hoes75755732h_oes
hokes126231642hokes
holes84748652holes
homes106938822homes
hones88144492hones
hopes105835642hopes
hoses85443182hoses
howes114730262howes
hubs96027142hub_s
hues75235232h_ues
hypes135818672hypes
jebel145612142jebel
jebels15418912jebels
jees115938542je_es
jefes155613672jefes
jetes124922842jetes
jibes145520322jibes
jubes145420742jubes
kexes166216822kexes
kibes115521122kibes
leben7314852leben
lebens8310092lebens
lees45455882le_es
leges64427292leges
lenes54738522lenes
leses54930812leses
lexes127225262lexes
lobes75331002lobes
lubes74727992lubes
mabes96331532mabes
memes94927702memes
meres75143572meres
metes74736212metes
mezes167719262mezes
nabes75427092nabes
nebs66124982neb_s
nenes55329672nenes
neves87021872neves
obes66036832_obes
pedes85327292pedes
pees65257372pe_es
pekes114623562pekes
peles75738082peles
penes75839222penes
peres76246642peres
phoebes1435812phoebes
plebes104313622plebes
pubes94423402pubes
rebbes10313532rebbes
rebec94416542rebec
rebecs103913672rebecs
rebel73421292rebel
rebels84518132rebels
rebs65733562reb_s
rebus75721112rebus
redes65139132redes
rees45364192re_es
reges65628792reges
rexes124526952rexes
rhemes115913182rhemes
ribes75530172ribes
robes75133302robes
rubes74928412rubes
sabes76437462sabes
sees45361052se_es
semes75731582semes
seres55448892seres
sexes126126222sexes
tabes76033922tabes
tees45353582te_es
teles54536002teles
thebe107515432thebe_
themes115319252themes
theres96525472theres
theses96517972theses
tubes74826452tubes
vees75439432ve_es
veges94118872veges
vexes155719122vexes
vibes104719952vibes
weber10313522weber
webers11310942webers
webs96622122web_s
wees76249122we_es
wheres125917442wheres
xebec16378292xebec
xebecs17355362xebecs
yeses85119322yeses
zebec18419262zebec
zebecs19316182zebecs
zebus164610052zebus
zees136331892ze_es

Search took 3 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.296603685.8
2DLD Change Limit538002181.64332745.0
3Display Results2182180.0603633.3
 (SQL Overall)1786912181.99989390.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.