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

354 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
sovran93715(None) 
sovrans1036481sovrans
loran55925092lo_ran
saran53730302s_aran
shoran94016042shoran
socman1039812socman
solan55328152so_lan
soldan73511852soldan
soman75024902so_man
soprani937402soprani
soprano937002soprano
sora45746912so_ra_
soras55041012so_ras
sorn46641062so_r_n
soudan73210352soudan
sovranly1443452sovranly
sovranty1443462sovranty
sporran936742sporran
anuran64313243anuran
avian84616053_avian
bodhran1343943bodhran
bogan87519003bo_gan
bora66141633bo_ra_
boral75831703bo_ral
borane84620213bo_rane
boras75938303bo_ras
borax145918723bo_rax
born67338413bo_r_n
boron76727143bo_ron
bourn75518483bour_n
bowman13129853bowman
bran65740383__bran
buran75225303_buran
cobra95214403cobra_
cobras104014193cobras
copra98115463copra_
coprah133710603coprah
copras103517153copras
coral76033453co_ral
corban10314693corban
corn69945813co_r_n
corral83616253corral
cotan71521783co_tan
courant9317973courant
courlan9117763courlan
covary1438743covary
coven106925043cov_en
covin105621123cov_in
cowman13910373cowman
curran8312023curran
divan96114843div_an
dobra85013103dobra_
dobras94811913dobras
dolman95312403dolman
doorman1037063doorman
doura66518663doura_
dourah10479813dourah
douras75016723douras
doven94718553dov_en
eolian6312593eolian
eonian6311833eonian
foeman11311233foeman
fora75937393fo_ra_
foram105124933fo_ram
foray115023973fo_ray
foreran10311793foreran
fovea11310483fovea_
foveae1237563foveae
foveal1237703foveal
foveas1238623foveas
furan84320013_furan
goban84414073go_ban
gooral7310463gooral
goral65125753go_ral
gossan747233gossan
govern1036823govern
gowan95415743go_wan
gran56335013__gran
hogan97817703ho_gan
honan85319773ho_nan
hoorah124411113hoorah
hooray123011373hooray
hora76136563ho_ra_
horah117922053ho_rah
horal86328683ho_ral
horas86333103ho_ras
horn76735613ho_r_n
isogram1047253isogram
joram145816983jo_ram
jordan1468063jordan
jovial1636543jovial
koan85425033ko__an
kora86431553ko_ra_
korai97018523ko_rai
koras95927113ko_ras
korat94934433ko_rat
korun9411923ko_run
loan47436453lo__an
lochan1139093lochan
logan68123283lo_gan
longan75612363longan
loral55927823lo_ral
lorans65117603lo_rans
lorn46435253lo_r_n
lovat8321043lov_at
moan65832023mo__an
moira71012023moira_
moirai886913moirai
moneran9311113moneran
mora66641273mo_ra_
morae75831193mo_rae
moral75533433mo_ral
moras76438773mo_ras
moray105423793mo_ray
morgan9311373morgan
morn66237563mo_r_n
moron76925423mo_ron
mourn77215013mour_n
nonfan948293nonfan
nonman8412363nonman
nova76518953nov_a_
novae85913123nov_ae
novas85215363nov_as
novena936763novena
ocean71212963_ocean
octan71313483_octan
okra86413573_okra_
okras94410973_okras
ora37250833_o_ra_
orad56031693_o_rad
oral47638123_o_ral
orang65119943_o_rang
organ6915393_organ
orra46120723_orra_
ourang73311063_ourang
outran63218893outran
ova66823793_ov_a_
oval77119523_ov_al
ovarian1037643_ovarian
ovary1149113_ovary
oven76624143_ov_en
overman12311463_overman
overran10311663_overran
pavan106518473pav_an
porn65636023po_r_n
potman102813573potman
pyran10514473_pyran
ran38266623___ran
reran57329103_reran
roan47234203ro__an
rodman949713rodman
roman75424823ro_man
roven85521973rov_en
rowan85418733ro_wan
sabra75317853sabra_
sabras85116363sabras
sacra74516993sacra_
sacral83414413sacral
sampan102511893sampan
sarans64224433s_arans
sarin55239253s_arin
satrap86212553satrap
saurian739913saurian
savant9416043sav_ant
savarin10310003savarin
savin84625083sav_in
scan65530453s__can
scarab10310063scarab
scorn75817443scor_n
scrag85916173s_crag
scram910621613s_cram
scrap97120403s_crap
seaman84015903seaman
seawan94111223seawan
sedan65620423s_edan
seitan62613233seitan
sera46141393s_era_
serac75925203s_erac
serai56830163s_erai
seral56336383s_eral
serin55434443s_erin
serrano768463serrano
serval93913413serval
servant10313623servant
seven84118313sev_en
several1039533several
sewan85921293s_ewan
sextan13389643sextan
shaman113314283shaman
sharn84823703shar_n
shopman14247263shopman
shorans102812413shorans
shorn85722183shor_n
showman15257293showman
shrank13359123s_hrank
siccan1037593siccan
sierran737193sierran
silvan92810153silvan
simian8811163simian
siren54525823s_iren
sirra54416323sirra_
sirrah9379753sirrah
sirras63814863sirras
skean94415623s_kean
skyman1535313skyman
slogan7539223slogan
sloven9389633slov_en
slurban944863slurban
snowman12226623snowman
soak87227663so__ak
soap65831133so__ap
soar46838673so__ar
soared74324293soared
soarer64522243soarer
soaring83521893soaring
soars54732513soar_s
soba64927923so_ba_
sobas74424253so_bas
soca66330053so_ca_
socas74026183so_cas
social8813333social
sockman1535663sockman
socmen1039193socmen
soda56329383so_da_
sodas64123543so_das
sodden84011513sodden
sofa75625603so_fa_
sofar86115493so_far
sofars94712783sofars
sofas85320713so_fas
softa86415183softa_
softas94410403softas
soften9429493soften
soiree62919483soiree
soja115619513so_ja_
sojas124716393so_jas
sokeman1337263sokeman
sola45541863so_la_
soland75115043so_land
solano65314183so_lano
solans64122493so_lans
solar55927343so_lar
soldans83210403soldans
solemn838643solemn
solion6616383solion
solon55026133so_lon
soma65635293so_ma_
somans84619303so_mans
somas76030373so_mas
son37761953so___n
sonant6621953so_nant
sonar56523423so_nar
sonarman1045563sonarman
sonars64818973sonars
sonorant8411703sonorant
soon46240503so__on
sopranos1046433sopranos
sorb68333043so_r_b
sorbs75022103so_rbs
sord56237203so_r_d
sords64527803so_rds
sore47059533so_r_e
sored66141783so_red
sorel56231443so_rel
sorer56236583so_rer
sores55454283so_res
sorgo64719723so_rgo
sori46039843so_r_i
soring74731883so_ring
sorns55028423so_rns
sororal7310653sororal
sorrel6413553sorrel
sorrow9339443sorrow
sorry84618253so_rry
sort46264813so_r_t
sorta57125413so_rta
sorts54536663so_rts
sorus54527583so_rus
souari6311383souari
soucar839323soucar
soudans8309353soudans
sour45935893sour__
source8410673source
soured74921863soured
sourer63620213sourer
souring83219063souring
sourly93612213sourly
sours55230503sour_s
soutane7312063soutane
soviet9720153soviet
sowans94215893so_wans
sowar85821343so_war
sowars94318013sowars
sowcar1135863sowcar
sown75127453so__wn
soya75724433so_ya_
soyas84520913so_yas
soybean1243953soybean
sozin14514543so_zin
span65234663s__pan
spartan948333spartan
spean74620513s_pean
spiral83715343spiral
spirant9814293spirant
sporal82915453sporal
sporrans1045523sporrans
sprag86418693s_prag
sprain83614863s_prain
sprang95713523s_prang
sprat76635973s_prat
spray106720063s_pray
spurn74815453spur_n
stern55319123ster_n
sterna63712763sterna
storax1389783storax
strain64919573s_train
strand74514823s_trand
strang75718313s_trang
strap77925263s_trap
straw813321293s_traw
stray88525573s_tray
styrax1675243styrax
suldan72611043suldan
sultan63012593sultan
sunray9310123sunray
suntan62613003suntan
supra73614253supra_
sura45740293s_ura_
surah86823253s_urah
sural55931263s_ural
suras55336323s_uras
surra55521343surra_
surras65919533surras
sutra54217933sutra_
sutras64818593sutras
svaraj1634963svaraj
swan76631313s__wan
swaraj1636023swaraj
sworn86115303swor_n
sylvan12257363sylvan
syren85216743s_yren
tolan55124013to_lan
toman75724053to_man
tora47545993to_ra_
torah87125273to_rah
toras55540373to_ras
torn46044253to_r_n
toucan838193toucan
van66246333__v_an
vouvray1641933vouvray
woman105818003wo_man
worn75631753wo_r_n
woven115215173wov_en
yourn87512773your_n

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.1401276364.3
2DLD Change Limit1127163546.11018447.8
3Display Results3543540.1103218.2
 (SQL Overall)1786913546.36028096.1
 
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.