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

344 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
alegar73928(None) 
alegars838931alegars
agar58726412a__gar
alar46340072al__ar
alga57927602al_ga_
algae65319622al_gae
algal66518212al_gal
algas65624932al_gas
algor6513052al_gor
alleger8319622alleger
almemar1144302almemar
altar55520642al_tar
alular6311352alular
anear55420322ane_ar
blear75918682ble_ar
clear76219052cle_ar
lear47045952_le_ar
legal65715942_legal
leger65721502_leger
abeam9316533abe_am
ablegate1147253ablegate
abler75624313able__r
aceta74017353aceta_
acetal84314903acetal
acinar8310483acinar
aegis6316783a_egis
afar76720783a__far
afeard1058263afe_ard
aga410447233a__ga_
agars66120643a__gars
agas55938843a__gas
ager55935843a__ger
agger76420893a_gger
agleam9158623agle_am
ahead96817053ahe_ad
ajar116217703a__jar
ajuga1335883ajuga_
ajugas1435263ajugas
akela9311343akela_
akelas10311193akelas
ala312463603al__a_
alae45643753al__ae
alan46844083al__an
alarm76621423al__arm
alary86123443al__ary
alas46358123al__as
alba68328333al_ba_
albas75925393al_bas
alcazar1843453alcazar
alder65421913al_der
ale36572343ale___
alec66430063ale__c
alecs76620733ale_cs
alee46652323ale__e
alef76340693ale__f
alefs87319663ale_fs
aleph10311393ale_ph
alephs1136533alephs
alert54740653ale_rt
alerter72111513alerter
alerts64418223alerts
ales47067103ale__s
alevin92511513alevin
alexia132910463alexia
alexias14249793alexias
alexin132311483alexin
alfa77624273al_fa_
alfas87219043al_fas
algebra1043043algebra
algid75415573al_gid
algin65718763al_gin
algors7312553al_gors
algum82711763al_gum
alias55834603al_ias
alidad838873alidad
aliener71011193aliener
alienor7116303alienor
alight103816863alight
align65016503alig_n
aligner8108303aligner
aligns75312953aligns
aliner65621983aliner
aliya83713483aliya_
aliyah12397493aliyah
aliyas93911803aliyas
allay85620393al_lay
allege74314643alleg_e
alleged9389313alleged
allegers9378233allegers
alleges84212563alleges
allegory1244293allegory
allegro844853allegro
allobar946663allobar
alma66333023al_ma_
almah106917253al_mah
almas76629773al_mas
almemars1243523almemars
almner85710723almner
aloha8513613aloha_
alohas9411703alohas
alpha1049653alpha_
alphas1139513alphas
altars64518153al_tars
alter54828503al_ter
alterer72713993alterer
alula5317093alula_
alulae6312743alulae
alveolar1143293alveolar
alway116113923al_way
ameba9312373ameba_
amebae1049633amebae
ameban1039093ameban
amebas10311453amebas
ameer75618983ame_er
amiga85514793amiga_
amigas95912163amigas
anears63717183ane_ars
anga56831353a_nga_
angary10311323a_ngary
angas65827983a_ngas
anger66225873a_nger
antiar6317173antiar
apeak115513453ape_ak
aper66336233ape__r
appear10379343appear
area45843393are_a_
areae55229743are_ae
areal55928733are_al
areas55935773are_as
areca75618633areca_
arecas84817443arecas
arena55323813arena_
arenas65021993arenas
areolar779223areolar
arepa75615563arepa_
arepas85515703arepas
argal65023383a_rgal
arrear6310253arrear
asea46327183ase_a_
ashlar9338193ashlar
assegai843353assegai
attar56516693a_ttar
auger64922473a_uger
augur64311213a_ugur
aurar54420253a_urar
avatar937523avatar
avenger1135493avenger
aver75931883ave__r
avgas96912133a_vgas
aweary1237303awe_ary
axeman1538103axeman
baler75635273bale__r
bear66844643_be_ar
began86319573_began
begat86629723_begat
beggar10328223beggar
belga8313233belga_
belgas9311713belgas
bleak115915383ble_ak
blears85116453ble_ars
bleary115112553ble_ary
bleat75737003ble_at
caesar8410933caesar
calamar1149293calamar
calcar10312753cal_car
calendar1145013calendar
calesa8412473calesa_
calesas9411823calesas
cedar84014323_cedar
cellar84514983cellar
cigar8911793_cigar
clean75420413cle_an
clears84116563cle_ars
cleat76335063cle_at
clever114611533clever
cougar958783cougar
dear55343603_de_ar
debar85517863_debar
degas75119163_degas
denar65223293_denar
dewar95817733_dewar
dogear838193dogear
drear65016903dre_ar
ear36867883__e_ar
egad64215413__egad
egal55119433__egal
eger55923563__eger
eggar7458883_eggar
elegant8311503elegant
elegiac1045453elegiac
elegit71212893elegit
elegy939303eleg_y
eyebar1135323eyebar
fanega1055783fanega_
fanegas1145713fanegas
fear75337793_fe_ar
feuar8310243_feuar
flea75628493fle_a_
fleam106017283fle_am
fleas86423663fle_as
fleer86020773fle_er
flexor1634503flexor
galea64722933gale_a_
galeae74717453gale_ae
galeas74618503gale_as
galena74911093galena_
galenas83310333galenas
gar47259903___gar
gear55934973_ge_ar
geegaw1142853geegaw
gleam86916733gle_am
glean65818203gle_an
gleba83910243gleba_
glebae9407613glebae
gleg66219803gleg__
glegly1134873glegly
haler85033523hale__r
hangar104114503hangar
hear76143883_he_ar
hegari1039513_hegari
ilea45931463ile_a_
ileac75814173ile_ac
ileal56118083ile_al
illegal854763illegal
jaeger14397193jaeger
kaleyard1683573kaleyard
kebar115113533_kebar
laager74312783laager
lagan66520343_lagan
lager65132863_lager
laggard10347623laggard
lagger85919833lagger
lahar83114263_lahar
langur7109303langur
laogai735983laogai
lar37967533_l__ar
larger74417513larger
lascar868573lascar
lazar144113643_lazar
lea37660183_le_a_
lead56038853_le_ad
leaf76441033_le_af
leak86233713_le_ak
leal46043273_le_al
lean46345243_le_an
leap66032683_le_ap
learn55322663_le_arn
lears55938733_le_ars
leary85927383_le_ary
leas45954183_le_as
ledger85914363_ledger
leer46239353_le_er
leg46446113_leg__
legacy1256653_legacy
legals73412733_legals
legate72917453_legate
legato72810953_legato
legator83011133_legator
legers74518313_legers
leges64427283_leges
leggy105210243_leggy
legit61323503_legit
legman949653_legman
legs56133693_leg_s
lehr75514943_le_hr
lekvar1333043_lekvar
leman75622603_leman
lemur739773_lemur
leper74820743_leper
leva77020713_leva_
lever85125163_lever
liar47229683_l_iar
lidar6312723_lidar
ligan67920283_ligan
liger65024463_liger
lobar7313013_lobar
logan68123283_logan
luger65322083_luger
lunar57017313_lunar
malar76424443mal__ar
mega77620873_mega_
megara9310093_megara
muggar10316443muggar
near45236503_ne_ar
olea46532723ole_a_
omega836383omega_
omegas936973omegas
palea75028663pale_a_
paleae84820293pale_ae
paleal84716673pale_al
paler75436933pale__r
palikar1335453palikar
palmar104113463pal_mar
pear69745233_pe_ar
plagal948573plagal
planar84212713planar
plea66830603ple_a_
plead85818463ple_ad
pleas75627033ple_as
pleat74734473ple_at
pledger11359153pledger
pledgor11334993pledgor
pleiad947833pleiad
plena75816393plena_
plenary1237543plenary
pleura837533pleura
plexal1536833plexal
plexor1535253plexor
prewar114712573prewar
realgar834873real_gar
rear45644553_re_ar
rebar75420193_rebar
regal65023793_regal
regard85215773_regard
regear73512743_regear
saggar84010853saggar
sangar73617683sangar
sear47353843_se_ar
seggar8357813seggar
sewar85421093_sewar
shear85424833she_ar
slogan7539223slogan
smear74416393sme_ar
spear75821063spe_ar
stelar64013863stelar
sugar6312913_sugar
swear85316853swe_ar
talar56225383tal__ar
taler56034863tale__r
tear45242883_te_ar
telega736773telega_
telegas837443telegas
thenar9269993thenar
ulema7109713ulema_
ulemas888963ulemas
ulnar56013983ul_nar
valvar12388653val_var
vegan95114153_vegan
velar85817633_velar
vinegar1134613vinegar
vulgar10426823vulgar
waler84229263wale__r
wear75836723_we_ar
year76534253_ye_ar

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.1561145455.1
2DLD Change Limit1127163446.57617140.5
3Display Results3443440.0933698.9
 (SQL Overall)1786913446.82526181.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.