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

470 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
solano6531418(None) 
solan55328151solan_
soland75115041soland
solanos74412851solanos
solans64122491solans
llano5910602_llano
poblano1145092poblano
romano84912942romano
silane62718052silane
slang66324022s_lang
slank95822772s_lank
slant55238702s_lant
sola45541862sola__
solace83415822solace
solands84412342solands
solanin7311942solanin
solanum946402solanum
solar55927342sola_r
solate64526072solate
soldan73511852soldan_
soldans83210402soldans
soldo67116562sol_do
soling74226822soling
solion6616382solion
solo45538942sol__o
solon55026132solon_
solons65120012solons
soman75024902soman_
somans84619302somans
sonant6621952sonant
soprano937002soprano
sowans94215892sowans
tolan55124012tolan_
tolane64316582tolane
tolans64319272tolans
volant9316322volant
volcano1244612volcano
alamo7418143_alamo
alan46844083_alan_
aland65526413_aland
alane56135613_alane
alang66023513_alang
alans55636173_alans
alant55742293_alant
aslant6317753aslant
beano75421553_beano
bland85320453_bland
blank115418553_blank
bogan87519003bogan_
bogans95714813bogans
bola66035563bola__
bolar75123473bola_r
bolas74733763bola_s
bolero8412093bolero
bolo65535953bol__o
bolson8410683bolson
borane84620213borane
botany1139263botany
calando1037383calando
clan65633923_clan_
clang86019313_clang
clank114719523_clank
clans75031013_clans
claro75018693_claro
cola66541393cola__
colas75436773cola_s
colin76231693colin_
colins85229043colins
colon78630193colon_
colone85425003colone
coloni85619203coloni
colons86028683colons
colony115417273colony
colugo935863colugo
coolant9316463coolant
coranto9311893coranto
cotan71521783cotan_
cotans81317923cotans
cyano105512493_cyano
doling84923133doling
dolman95312403dolman_
dolmans10479683dolmans
domino92611493domino
dopant9316133dopant
dorado838813dorado
elan46734243_elan_
eland65820393_eland
elans55527753_elans
eolian6312593eolian_
fano75831683__fano
flan76134183_flan_
flank124618093_flank
flans85327973_flans
folate93320393folate
folio83820883fol_io
galago838903galago
gelant72821673gelant
gelato73812953gelato
gitano738043gitano
gland75217713_gland
glans65125833_glans
goban84414073goban_
gobang10376703gobang
gobans94412043gobans
gowan95415743gowan_
gowans105512293gowans
gowany13457493gowany
guano69213983_guano
hogan97817703hogan_
hogans105914313hogans
holard10410573holard
holing104025073holing
holland11349473holland
hollo84822163hol_lo
holloo94415253holloo
honan85319773honan_
honans94814503honans
inland7310313inland
island738533island
isolate7313923isolate
isolator847533isolator
isoline7314013isoline
journo13135293journo
koan85425033ko_an_
koans95818623ko_ans
kola85124963kola__
kolas94822233kola_s
kolo87026223kol__o
land56337303__land
lane45153323__lane
lang56637373__lang
lank84734443__lank
leno47331393__leno
lino46343373__lino
llanos6108333_llanos
loan47436453lo_an_
loans56026463lo_ans
logan68123283logan_
logans76319063logans
loran55925093loran_
lorans65117603lorans
lowland1134693lowland
mano66536793__mano
moan65832013mo_an_
moans74624363mo_ans
mola66035633mola__
molal75120343mola_l
molar75223093mola_r
molars85517323molars
molas75132093mola_s
moline84422033moline
molto75619603mol_to
mono66036713mo__no
nolo46229313nol__o
norland837163norland
oleo46630483_ol_eo
olingo736933_olingo
olio46829673_ol_io
ono36838033_o__no
oolong738073oolong
orang65119943_orang
piano76118713_piano
plan65833943_plan_
plane74929143_plane
plank115221143_plank
plans75731273_plans
plant75437113_plant
poblanos1244993poblanos
polar75623453pola_r
polaron939843polaron
polars84419353polars
poling93526503poling
polio75722553pol_io
polo66236633pol__o
pompano1345203pompano
porno75120653po_rno
potato8513433potato
prolan8414693prolan_
prolans9314273prolans
reland75920433reland
roan47234203ro_an_
roans54926443ro_ans
robalo838923robalo
roband92310723roband
roman75424823roman_
romanos94311473romanos
romans84620243romans
rowan85418733rowan_
rowans95715343rowans
sago56332673s__ago
salaam8711013salaam
salad65321833sala_d
salads75316963salads
salal55425703sala_l
salals65120083salals
salami8313103salami
salary9515213salary
salina64221123salina
saline65132703saline
salmon84614183salmon
salon55228553salon_
salons63823683salons
saloon64418023saloon
saltant7316773saltant
salvo84415643sal_vo
sand55338463s__and
sane45954333s__ane
sang55441223s__ang
sank85236823s__ank
sans45153353s__ans
santo56227283s__anto
saran53730303saran_
sarans64224433sarans
satang75711563satang
savant9416043savant
scalado10276473scalado
scan65530453s_can_
scans74625103s_cans
scant79735073s_cant
sclaff1438313sclaff
sealant73118303sealant
secant84023293secant
sedan65620423sedan_
sedans74816093sedans
segno64814743s_egno
sejant133114483sejant
selah8319613sela_h
selahs9313213selahs
serrano768453serrano
sewan85921293sewan_
sewans95215903sewans
shako125516083s_hako
shank125422193s_hank
shoran94016033shoran_
shorans102812403shorans
shrank13359123shrank
silage72715303silage
silanes72517163silanes
sileni63312143sileni
silent64125843silent
silo46037913sil__o
silvan92810153silvan_
silvans10308323silvans
skank84415583s_kank
skean94415623skean_
skeane104611373skeane
skeans104512913skeans
sklent103614353sklent
slab67133763s_la_b
slabs75322643s_labs
slack115021763s_lack
slag55934353s_la_g
slags66525903s_lags
slain54923573s_lain
slake93724053s_lake
slalom888173s_lalom
slam67737973s_la_m
slams74927903s_lams
slangs75615343s_langs
slangy105411393s_langy
slants64819083s_lants
slanty95114843s_lanty
slap66434043s_la_p
slaps76025713s_laps
slash84719683s_lash
slat46959023s_la_t
slate55438283s_late
slats55436903s_lats
slaty86523153s_laty
slave84224033s_lave
slaw77930713s_la_w
slaws85222713s_laws
slay76436383s_la_y
slays85723683s_lays
sleazo15257523sleazo
sling66028803s_ling
slink95422913s_link
slogan7539223slogan_
slogans8407983slogans
slung65117833s_lung
slunk95016303s_lunk
smalto84410283smalto
snowland1243833snowland
soak87227663so_a_k
soaks95220293so_aks
soap65831133so_a_p
soaps75120713so_aps
soapy106114783so_apy
soar46838673so_a_r
soars54732513so_ars
soave84219053so_ave
soba64927923soba__
sobas74424253soba_s
soca66330053soca__
socage91012123socage
socas74026183soca_s
socko115215113so_cko
socman1039813socman_
soda56329383soda__
sodas64123543soda_s
sofa75625603sofa__
sofar86115493sofa_r
sofars94712783sofars
sofas85320713sofa_s
soigne74310033soigne
soilage8169353soilage
soiling83422323soiling
soja115619513soja__
sojas124716393soja_s
sol37256623sol___
solaced102911063solaced
solacer93011103solacer
solaces93116133solaces
solacing11310133solacing
solander948123solander
solanine8311533solanine
solanins8310513solanins
solanums1044433solanums
solaria7312493solaria
solated83618023solated
solates73523853solates
solatia7312243solatia
solating9315593solating
solation8916153solation
sold54837413sol__d
solder73921343solder
soldi65717193sol_di
sole46053673sol__e
soled65835173sol_ed
solei55624333sol_ei
solely93714213solely
solemn838643solemn
solenoid947873solenoid
soles55547923sol_es
soleus64615613soleus
solgel737963solgel
soli46637003sol__i
solid65025073sol_id
solidago1042773solidago
solidi73813153solidi
solids74116403solids
solions7513743solions
soliton7410233soliton
soloed74515743soloed
soloing82813803soloing
solos54830793sol_os
sols45448163sol__s
solum74717603sol_um
solums85211333solums
solunar735283solunar
solus54726983sol_us
solute64016663solute
solvate102710213solvate
solve85618943sol_ve
solved105312933solved
solvent10310833solvent
solver94016703solver
solves95018223solves
solving112910853solving
soma65635293soma__
somas76030373soma_s
somata8312383somata
somoni8310733somoni
son37761953so__n_
sonance9310313sonance
sonants7511233sonants
sonar56523423sona_r
sonars64818973sonars
sonata6313223sonata
sone46649983so__ne
song55133673so__ng
sonny85016103so_nny
sons46049553so__ns
soon46240503so_on_
soprani937403soprani
sopranos1046433sopranos
sora45746913sora__
soras55041013sora_s
sordino8219443sordino
sorgho10348713sorgho
sorgo64719723so_rgo
soring74731883soring
sorn46641063so_rn_
sorns55028413so_rns
souari6311373souari
soudan73210353soudan_
soudans8309353soudans
sound64420023so_und
soutane7312063soutane
sovran937153sovran_
sovrans1036483sovrans
sowar85821343sowa_r
sowars94318003sowars
sowens93613153sowens
sowing104222913sowing
sown75127453so_wn_
soya75724433soya__
soyas84520913soya_s
sozin14514523sozin_
sozine15712343sozine
sozins15510783sozins
spado83713703s_pado
span65234663s_pan_
spang84919733s_pang
spank115919573s_pank
spans74528733s_pans
spean74620513spean_
speans85417143speans
splake1259783splake
splash1168823splash
splat76129343spla_t
splats84817303splats
splay105816043spla_y
splays114910873splays
splent84720193splent
spline86020533spline
splint85223283splint
sprang95713523sprang
stand65923283s_tand
stane55933003s_tane
stang66424683s_tang
stank95823303s_tank
stanol6310723s_tanol
steno54716863s_teno
stolen64315063stolen_
stolon64112063stolon_
stolons73410233stolons
strand74514823strand
strang75718313strang
suldan72611043suldan_
suldans8299723suldans
sulfo8313363sul_fo
sultan63012593sultan_
sultana7257803sultana
sultans72411833sultans
sunland837473sunland
swan76631313s_wan_
swang95519723s_wang
swank125318233s_wank
swans84625013s_wans
sylvan12257363sylvan_
sylvans13235893sylvans
synanon1044743synanon
tola45236333tola__
tolanes74216313tolanes
tolar55524113tola_r
tolars64817923tolars
tolas54532773tola_s
toledo7419993toledo
toling73926123toling
toman75724053toman_
tomans85419133tomans
tomato8313453tomato
troland837543troland
uhlan849113uhlan_
uhlans937573uhlans
ulan46527393_ulan_
ulans54921303_ulans
upland938863upland
volante1038513volante
volar86917413vola_r
volcanos1344733volcanos
voling103918023voling
woman105818003woman_
womans114613653womans
xylan1537463xylan_
xylans1635883xylans
yulan8411493yulan_
yulans958673yulans
zocalo1735803zocalo

Search took 6 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.1401276364.3
2DLD Change Limit1127164705.59620142.2
3Display Results4704700.1403357.1
 (SQL Overall)1786914705.87630410.3
 
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.