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

143 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
ebbs8241199(None) 
ebb72418631ebb_
abas68642082abas
abba810522652abba
abbas95918642abbas
abbe87627192abbe
abbes96723522abbes
abos67734412abos
abs59356072_abs
abys97221882abys
albs68628572albs
arbs66834732arbs
bas58681752_bas
beds75937782beds
bees65453382bees
begs75733832begs
bels66142492bels
bens65945702bens
bes56557432_bes
bets67051442bets
beys913829552beys
bibbs84911582bibbs
bibs84830992bibs
bis56860662_bis
bobs86340652bobs
bos57966812_bos
bubs86235502bubs
bus56950972_bus
bys85229462_bys
cabs86739422cabs
cobbs115013992cobbs
cobs87043142cobs
cubs85832382cubs
dabs77139402dabs
debs76530242debs
debts86418372debts
dibs76233682dibs
dubs78432192dubs
ears46356592ears
eats47054872eats
ebbed104111002ebbed
ebbet93517292ebbet
ebbets10376832ebbets
ebon66821102ebon
ebons74316092ebons
ecus65421462ecus
edhs86212102edhs
eds46638922e_ds
eels46536742eels
effs105114032effs
efs66829602e_fs
efts76519482efts
eggs66516152eggs
egis56520652egis
egos55821652egos
ekes86726602ekes
elds56324852elds
elks85820032elks
ells46431352ells
elms67322702elms
els37645722e_ls
emes65434662emes
ems56435492e_ms
emus66821682emus
ends56528522ends
engs56121392engs
ens37245922e_ns
eons46638712eons
epos66723732epos
eras45441502eras
ergs55523812ergs
erns45428232erns
eros45238452eros
errs45622532errs
ers36046282e_rs
es29048222e__s
eses45336102eses
ess36030882e_ss
etas46432272etas
eths76619522eths
eves76230462eves
ewes76328702ewes
exes116530812exes
eyas76427432eyas
eyes75837882eyes
fabs98635862fabs
feebs106112682feebs
fibs96329502fibs
fobs96034272fobs
fubs96328792fubs
gabs76740422gabs
gibs75529272gibs
gobs76935572gobs
hebes105521672hebes
herbs105520502herbs
hobs97038982hobs
hubs96027142hubs
ibis66519582ibis
jabs135830092jabs
jibbs16609742jibbs
jibs136724082jibs
jobs136529432jobs
kabs107130842kabs
kebabs14418512kebabs
kebobs14427292kebobs
kerbs115013672kerbs
kobs105831082kobs
labs67145122labs
libs66732762libs
lobs66441082lobs
mibs85330482mibs
mobs85737372mobs
nabs66236192nabs
nebs66124982nebs
nibs65028312nibs
nobs66436902nobs
nubs65927142nubs
obas65730932obas
obes66036832obes
obis66226842obis
orbs66626252orbs
pubs85029212pubs
rebbe9313162rebbe
rebbes10313532rebbes
rebs65733562rebs
rebus75721112rebus
ribs65833022ribs
robs65837872robs
rubs66133492rubs
sabs66643742sabs
sibbs96211902sibbs
sibs65933542sibs
sobs64941752sobs
subs66037122subs
tabs66842982tabs
tubs65430062tubs
urbs65922062urbs
verbs104614392verbs
wabs97337232wabs
webby1537152webby
webs96622122webs
yobs96028082yobs
zebus164610052zebus

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.266671770.7
2DLD Change Limit298721430.83035990.4
3Display Results1431430.0304766.7
 (SQL Overall)1786911431.126158695.4
 
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.