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

209 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
hebe9642470(None) 
hebes105521671hebes
heme95034411heme
here76447101here
thebe107515431thebe
abbe87627182abbe
babe86835812babe
be47948942__be
bee56262402be_e
bene66439492bene
cede74928762cede
cee55952702ce_e
cepe84926652cepe
cere66741472cere
cete64934782cete
chebec1536962chebec
cube85830212cube
deb66342692deb_
debs76530242debs
debt77139022debt
debye1138902debye
dee47665822de_e
deke95228762deke
dele56843082dele
deme76536282deme
dene56643412dene
dere56845902dere
ebb72418622_ebb
eke75630092_eke
eme55837182_eme
ephebe1336062ephebe
ere36352772_ere
eve66331162_eve
ewe66630982_ewe
eye65539772_eye
fee66862012fe_e
feeb96924542feeb
feme96130542feme
fere76342232fere
fete75734922fete
gee45359202ge_e
gene56237222gene
ghee85726112ghe_e
gibe75927772gibe
glebe85016442glebe
grebe85114942grebe
gybe105916242gybe
habu97325482habu
hade85440192hade
hae67364002h_ae
hake115637842hake
hale76052832hale
hame97043132hame
hare76255732hare
hate78450172hate
have106137072have
haze164833392haze
he58151952h__e
head87137172head
heal75645692heal
heap96432892heap
hear76143882hear
heat77061422heat
heave114521812heave
heck135826492heck
heder95623632heder
hedge105317332hedge
heed86437602heed
heel75034222heel
heeze175313482heeze
heft106736292heft
heh96039622he_h
hehs106723962hehs
heil76328932heil
heir77523802heir
held85330402held
hell75637892hell
helm95530022helm
helo75332852helo
help95328922help
helve115018092helve
hem86148732he_m
hemes105031082hemes
hemp115725622hemp
hems95534942hems
hen67555272he_n
hence104920042hence
henge94819822henge
hens75642572hens
hent76656382hent
hep86644142he_p
her66547812he_r
herb94730962herb
herbed123513452herbed
herbs105520502herbs
herby134715312herby
herd84933062herd
heres86245902heres
herl75834552herl
herm95636152herm
hern76134892hern
hero74635782hero
hers75844872hers
hes66654202he_s
hest75950772hest
het67674312he_t
heth107028022heth
hets75547202hets
hew97642722he_w
hewed125619432hewed
hewer115719932hewer
hewn106719852hewn
hews105631572hews
hex137436172he_x
hexed165615762hexed
hexer155116682hexer
hexes155123042hexes
hey96741062he_y
hide85134622hide
hie67652702h_ie
hike116830392hike
hire75538962hire
hive106029672hive
hob87550922hob_
hobo97026082hobo
hobs97038982hobs
hoe67562722h_oe
hoke115935932hoke
hole77553392hole
home98042442home
hone77549322hone
hope96639672hope
hose76547242hose
hove107132222hove
howe106734102howe
hub86437482hub_
hubs96027142hubs
hue66642302h_ue
huge86321652huge
hype125519812hype
hyte109018942hyte
jebel145612142jebel
jee106648642je_e
jefe146516882jefe
jete115927252jete
jibe136323382jibe
jube136322782jube
kibe106523432kibe
leben7314852leben
lee36068142le_e
leke85527402leke
lobe65535362lobe
lube64731562lube
mabe85733342mabe
meme85330552meme
mere67244442mere
mete64438132mete
meze154420902meze
nabe66029492nabe
neb57238622neb_
nebs66124982nebs
nee36657782ne_e
nene45932062nene
neve76224832neve
obe56638642_obe
pee56066512pe_e
peke105926202peke
pele65539552pele
pere66450262pere
phoebe1335002phoebe
plebe95014872plebe
reb55844962reb_
rebbe9313152rebbe
rebec94416542rebec
rebel73421292rebel
rebs65733562rebs
rede55037662rede
ree37974072re_e
rete44944132rete
rheme106214052rheme
robe65335642robe
rube65532012rube
sabe66140572sabe
see35772262se_e
seme65836652seme
sene46848052sene
sere46153472sere
tee38366872te_e
tele45040872tele
thebes115914492thebes
thee78039062the_e
theme105921732theme
there87527392there
these86519012these
tube65828662tube
unbe65319272unbe
vee65750182ve_e
vibe95124492vibe
web85735562web_
weber10313522weber
webs96622122webs
wee66760812we_e
were76238332were
whee105429592whe_e
where117019422where
xebec16378292xebec
zebec18419262zebec
zebu153414722zebu
zee126143232ze_e

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.1261418182.5
2DLD Change Limit298722091.17025531.6
3Display Results2092090.0932247.3
 (SQL Overall)1786912091.389128647.2
 
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.