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

282 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
albs6862857(None) 
abs59356071a_bs
alas46358121alas
alb57342651alb_
alba68328331alba
albas75925391albas
ales47067101ales
alls46740921alls
alms65834921alms
alps65529241alps
als36663021al_s
alts46639901alts
arbs66834731arbs
labs67145121labs
aahs716428562aahs
aals49941142aals
aas310975392a_as
ab410674762a_b_
aba512850952a_ba
abas68642082abas
abba810522642abba
abbas95918642abbas
abbe87627182abbe
abbes96723522abbes
able66340532able
ables75935542ables
ably99725132ably
abo59045962a_bo
abos67734412abos
aby810238062a_by
abys97221882abys
aces67645092aces
acts66929862acts
adds67622452adds
ados57633512ados
ads49755732a_ds
agas55938842agas
ages55844592ages
ags47551662a_gs
ahis76135382ahis
ahs68644822a_hs
aids57846352aids
ails45654712ails
aims67738182aims
ains46158882ains
airs46447422airs
ais39083572a_is
aits46355532aits
al210674042al__
ala312463602al_a
alae45643752alae
alan46844082alan
alans55636172alans
alar46340072alar
album92312652album
albums10198272albums
ale36572342al_e
alec66430062alec
alecs76620732alecs
alee46652322alee
alef76340692alef
alefs87319662alefs
alfa77624272alfa
alfas87219042alfas
alga57927602alga
algas65624932algas
alias55834602alias
alibi7514222alibi
alibis8311072alibis
alif76242132alif
alifs86121262alifs
alist56136782alist
alit46155692alit
alky115920342alky
all36148232al_l
ally76935642ally
alma66333022alma
almas76629772almas
alme65832162alme
almes75126542almes
aloe45540192aloe
aloes54933672aloes
alow75328592alow
alp56641132al_p
also46423442also
alt36467962al_t
alto47831262alto
altos55822952altos
alum65227612alum
alums75720602alums
amas67746292amas
ambo88225132ambo
ambos95321242ambos
amis66445312amis
amps86230342amps
amus65529612amus
anas46649862anas
ands57833612ands
anes45255932anes
anis45746462anis
anlas55626932anlas
ants47243472ants
anus47131112anus
apes66047432apes
apos65433822apos
apps86319692apps
arb510448422arb_
arcs67834782arcs
ares45871022ares
arfs76029962arfs
arks85936872arks
arles56735742arles
arms66137492arms
ars37670932a_rs
arts49650262arts
as211083072a__s
asks85721212asks
asps65622092asps
ass37844062a_ss
ates45047922ates
atlas55821582atlas
auks85525262auks
aves76142602aves
avos77227012avos
awes76037552awes
awls75926092awls
awns75324432awns
axes117337852axes
axis116127912axis
axles125219472axles
ayes76543512ayes
ays67050292a_ys
balas76937212balas
balds85524642balds
bales76250082bales
balks114926292balks
balls76236412balls
balms95723922balms
bals66354042bal_s
barbs95928192barbs
bibs84830972bibs
blabs95619632blabs
blebs96416152blebs
blobs95620032blobs
blubs95818152blubs
bobs86340642bobs
bubs86235492bubs
bulbs96016932bulbs
cabs86739422cabs
calfs104919382calfs
calks115421602calks
calls75634732calls
calms95222352calms
calos74431902calos
carbs96031462carbs
clubs95415102clubs
cobs87043142cobs
cubs85832382cubs
dabs77139402dabs
dales66439742dales
dals57145122dal_s
darbs85323262darbs
daubs85014562daubs
debs76530242debs
dibs76233672dibs
dubs78432192dubs
ebbs82411982ebbs
elds56324852elds
elks85820032elks
ells46431352ells
elms67322702elms
els37645722el_s
fabs98635862fabs
falls85727652falls
fibs96329492fibs
flabs105818642flabs
flubs105515442flubs
flus75626542flus
fobs96034272fobs
fubs96328792fubs
gabs76740422gabs
galas65731642galas
gales65442482gales
galls64729322galls
gals57946502gal_s
gambs105721122gambs
garbs86321412garbs
gibs75529262gibs
globs85616402globs
gobs76935572gobs
hales85449842hales
halls85633782halls
halms105225212halms
halos85230252halos
halts85230102halts
hobs97038982hobs
hubs96027142hubs
iambs95815052iambs
ilks87218572ilks
ills47030422ills
jabs135830092jabs
jambs166014622jambs
jibs136724072jibs
jobs136529432jobs
kabs107130842kabs
kales95730982kales
kobs105831082kobs
lab58864782lab_
lacs66942482lacs
lads56549132lads
lags56546222lags
lalls55324132lalls
lambs95921412lambs
lams66552262lams
laps66848872laps
lars46956572lars
las37281472_las
lass47444542lass
lats45962702lats
lavs76734152lavs
laws76441682laws
lays76043252lays
les35663072_les
libs66732752libs
lis37162272_lis
lobs66441082lobs
males75049792males
malls76233432malls
malms95021552malms
malts76331752malts
mibs85330462mibs
mobs85737362mobs
nabs66236192nabs
nalas55528362nalas
nebs66124982nebs
nibs65028302nibs
nobs66436902nobs
nubs65927142nubs
olds55926572olds
oles46453472oles
orbs66626252orbs
pales75753802pales
palls74332562palls
palms94921752palms
palps94719562palps
pals66951352pal_s
plebs95814582plebs
plus66324832plus
pubs85029212pubs
rales54947492rales
rebs65733562rebs
ribs65833012ribs
robs65837872robs
rubs66133492rubs
sabs66643742sabs
sales56055592sales
salps74423242salps
sals46851672sal_s
salts55431882salts
sibs65933532sibs
slabs75322642slabs
slobs74419872slobs
slubs74719532slubs
sobs64941752sobs
subs66037122subs
tabs66842982tabs
talas55935892talas
talcs74817182talcs
tales55451372tales
talks94322692talks
talls55133432talls
talus55423262talus
tubs65430062tubs
ulus45622562ulus
urbs65922052urbs
vales85434262vales
wabs97337232wabs
wales86142832wales
walks126218502walks
walls85529382walls
webs96622122webs
yobs96028082yobs

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.0762351197.4
2DLD Change Limit298722821.01629401.6
3Display Results2822820.0634476.2
 (SQL Overall)1786912821.155154710.8
 
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.