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 “albedo” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

261 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
albedo95612(None) 
albedos1075251albedos
abed79734132a_bed_
abled86926832abled_
albedoes1184532albedoes
albeit8314342albeit
albino839922albino
alfredo1142482alfredo
aahed917816443aahed_
abbe87627183abbe__
abbes96723523abbe_s
abbess10509773abbess
abbey125714933abbe_y
abbeys13538423abbeys
abeam9316533a_beam
abele76323253a_bele
abet610547943a_be_t
abets75621673a_bets
abide86223703a_bide
able66340533able__
abler75624313able_r
ables75935543able_s
ablest84721833ablest
abmho1236793a_bmho
abo59045963a_b__o
abode85518813a_bode
accede1138293accede
aced79540883a_ced_
ached119227833ached_
acned87520663acned_
acred87126353acred_
acted88521733acted_
added84918433added_
ado49146873a___do
adzed166012543adzed_
aero45435343a__ero
aged67334253a_ged_
ahed89536253a_hed_
aided75828933aided_
aikido1135473aikido
ailed66240283ailed_
aimed85626053aimed_
aired66032923aired_
alae45643753alae__
alameda1035493alameda
alamo7418143al_amo
aland65526413aland_
alands75418373alands
alated75625143alated_
alb57342653alb___
alba68328333alb__a
albas75925393alb_as
albata839333albata
albinos937653albinos
albite8313303albite
albs68628573alb__s
album92312653alb_um
albums10198273albums
alcade91111513alcade
alcid85817963alcid_
alcids94812293alcids
alder65421913alde_r
alders74218423alders
aldol61212333al__dol
ale36572343al_e__
alec66430063al_e_c
alecs76620733al_ecs
alee46652323al_e_e
alef76340693al_e_f
alefs87319663al_efs
aleph10311393al_eph
alert54740653al_ert
ales47067103al_e_s
algid75415573algid_
alibied1038143alibied_
alien56425583alie_n
alienor7116303alienor
aliens65619213aliens
alined75221403alined_
aliped95414283aliped_
alipeds10386793alipeds
alkene104114003alkene
alkyd13537093alkyd_
alkyds14404363alkyds
allee54932123alle_e
allees64521483allees
allege74314643allege
allegro844853allegro
allele64514563allele
alley85721673alle_y
alleys95113303alleys
allied74217153allied_
allod64418373allod_
allods73615083allods
allude73910903allude
alme65832163alme__
almeh106214553alme_h
almehs11619493almehs
almes75126543alme_s
almud84012183almud_
almude9399933almude
almuds9378773almuds
alnico877943alnico
aloe45540193aloe__
aloes54933673aloe_s
aloud65018063aloud_
already1144263already
also46423443al__so
alter54828503alte_r
alters64924223alters
altho86312603al_tho
alto47831263al__to
aludel747853aludel
ambeer104511593ambeer
amber94523203ambe_r
ambers104519563ambers
ambery133811123ambery
ambled115116353ambled_
ambo88225133amb__o
amido85720963a_mido
amped104820513amped_
anted66328243anted_
aped78538153a_ped_
arced88224163arced_
armed86324433armed_
arseno6318913arseno
ashed97829773ashed_
asked106919313asked_
aubade939223aubade
awed88436033a_wed_
awned96615953awned_
axed128829613a_xed_
axled135315813axled_
azido155411543a_zido
balded105417513balded_
baled85436443bal_ed_
balked135219413balked_
balled94926893balled_
barbed115121313barbed_
bed67950623__bed_
beds75937783__beds
bedu75923693__bedu
bled75729313bl_ed_
bleed85019803bleed_
bleeds95211593bleeds
blued84520323blued_
bulbed114312773bulbed_
cabbed135416263cabbed_
cabled114819873cabled_
calando1037383calando
calked134617403calked_
called94126733called_
calmed114816383calmed_
calved125215453calved_
clued84917683clued_
comedo11359603comedo
credo84815563_credo
cubed105519703cubed_
dabbed124416143dabbed_
daledh1133743dal_edh
daubed104611783daubed_
daybed13438673daybed_
daybeds14234473daybeds
ebbed104111003ebbed_
embed105014293embed_
embeds11377893embeds
fabled124216383fabled_
fled85429773fl_ed_
flied96519433flied_
flued95021253flued_
foredo10510823foredo
gabbed125216893gabbed_
gabled105518453gabled_
galled84622853galled_
gambado1344973gambado
garbed104815663garbed_
gibed96215963gibed_
gled65631143gl_ed_
glede75517833gl_ede
gleds75417893gl_eds
gleed75320573gleed_
gleeds84711623gleeds
globed104811763globed_
glued75118363glued_
gybed125811023gybed_
halberd1336043halberd
halberds1435173halberds
halbert12314503halbert
haled95335823hal_ed_
haloed104717593haloed_
halted105019603halted_
halved134813903halved_
imbed105013633imbed_
imbeds11456723imbeds
jabbed184213483jabbed_
jambed184811403jambed_
jibed155114163jibed_
label75019383labe_l
labels84515683labels
laced87132643laced_
laded74232613laded_
laevo849363_laevo
laked105731123laked_
lalled74218753lalled_
lambed115614783lambed_
lamed85235293lamed_
lamedh12476363lamedh
lameds94812033lameds
lased65132343lased_
lated65240673lated_
laved95028593laved_
lawed96028323lawed_
layed95127383layed_
lazed154925843lazed_
led46254553_l_ed_
leno47331393_l_eno
levo76820063_l_evo
libido935743libido
lido56028153_l_ido
lied55838093_lied_
lobed86022133lobed_
lubed85319893lubed_
malfed12369753malfed_
malled94626103malled_
malted94819853malted_
malteds10377603malteds
nabbed115113613nabbed_
naled65525053nal_ed_
naleds7469133nal_eds
oleo46630483ol_e_o
orbed85516193orbed_
paled85538723pal_ed_
palled94625163palled_
palmed114314643palmed_
palped114513643palped_
pled75231433pl_ed_
plied85118593plied_
redo56029363__redo
robed85323733robed_
sabbed114518083sabbed_
sabed86526813sabed_
salted74121203salted_
salved103916423salved_
sled55334373sl_ed_
sleds64418853sl_eds
slued64220513slued_
speedo94011993speedo
tabbed114215363tabbed_
tabled94020043tabled_
talced93811003talced_
talked114015403talked_
teredo7310783teredo
toledo7419993toledo
tubed85818043tubed_
tuxedo1433133tuxedo
uredo65112993_uredo
valued104011153valued_
valved136711043valved_
waled94330993wal_ed_
walked145313783walked_
walled104021293walled_

Search took 7 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 Filter1786911127160.1701051123.5
2DLD Change Limit1127162616.12618399.6
3Display Results2612610.0763434.2
 (SQL Overall)1786912616.37228043.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.