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

262 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
sovrans103648(None) 
sovran937151sovran_
lorans65117602lo_rans
sarans64224432s_arans
shorans102812412shorans
solans64122492so_lans
soldans83210402soldans
somans84619302so_mans
soprani937402soprani
soprano937002soprano
sopranos1046432sopranos
soras55041012so_ra_s
sorns55028422so_r_ns
soudans8309352soudans
sovranly1443452sovranly
sovranty1443462sovranty
sowans94215892so_wans
sporrans1045522sporrans
anurans73810553anurans
avians93711563_avians
bodhrans1443543bodhrans
bogans95714813bo_gans
borals86721913bo_rals
borane84620213bo_rane
boranes93720403bo_ranes
boras75938303bo_ra_s
borons85520543bo_rons
bourns84114063bour_ns
brans75437433__brans
burans85019303_burans
cobras104014193cobra_s
coprahs14338153coprahs
copras103517153copra_s
corals85325143co_rals
corbans11313173corbans
corns76034763co_r_ns
corrals93713853corrals
cotans81317923co_tans
courant9317973courant
courants10310803courants
courlans10117613courlans
covens114919263cov_ens
covins114618063cov_ins
currans9310613currans
divans104612393div_ans
dobras94811913dobra_s
dolmans10479683dolmans
dourahs11487253dourahs
douras75016723doura_s
dovens104413903dov_ens
forams115115913fo_rams
forays124813003fo_rays
foveas1238623fovea_s
furans94515953_furans
gobans94412043go_bans
goorals838703goorals
gorals76917653go_rals
gossans836783gossans
governs1136103governs
gowans105512293go_wans
grans64832543__grans
hogans105914313ho_gans
honans94814503ho_nans
hoorahs13399603hoorahs
hoorays13418373hoorays
horahs126313873ho_rahs
horas86333103ho_ra_s
horns86125333ho_r_ns
isograms1146473isograms
jorams154810533jo_rams
jordans1566833jordans
koans95818623ko__ans
koras95927113ko_ra_s
korats105416063ko_rats
loans56026463lo__ans
lochans1248833lochans
logans76319063lo_gans
longans84510813longans
loran55925093lo_ran_
lovats939073lov_ats
moans74624373mo__ans
monerans10310343monerans
morals85324633mo_rals
moras76438783mo_ra_s
morass84614503mo_rass
morays114613883mo_rays
morgans10310123morgans
morns75527443mo_r_ns
morons84919543mo_rons
mourns84111013mour_ns
nonfans1037533nonfans
novas85215363nov_a_s
novenas1036893novenas
oceans81211003_oceans
octans81411143_octans
okras94410973_okra_s
orals55826483_o_rals
orang65119943_o_rang
orangs74116033_o_rangs
organs7912913_organs
ourang73311063_ourang
ourangs8318503_ourangs
ovals85413393_ov_als
ovens86217453_ov_ens
overmans13310313_overmans
pavans115715593pav_ans
porns75527343po_r_ns
pyrans11411063_pyrans
roans54926443ro__ans
romans84620243ro_mans
rowans95715343ro_wans
sabras85116363sabra_s
sacrals93311793sacrals
sampans112411003sampans
sans45153363s___ans
saran53730303s_aran_
sarins63932623s_arins
satraps95011643satraps
saurians837763saurians
savant9416043sav_ant
savants1038653sav_ants
savarins1139893savarins
savins93923133sav_ins
scans74625103s__cans
scarabs1137293scarabs
scorns85713023scor_ns
scrags95713803s_crags
scrams105216623s_crams
scraps106017243s_craps
seawans10379943seawans
sedans74816093s_edans
seitans73312303seitans
seracs84418573s_eracs
serais64326133s_erais
serins64029673s_erins
serrano768463serrano
serranos857873serranos
servals103410743servals
servant10313623servant
servants1137993servants
sevens93813663sev_ens
severals1137593severals
sewans95215903s_ewans
sextans14349263sextans
shamans123610903shamans
sharns95516983shar_ns
shoran94016043shoran_
shrank13359123s_hrank
silvans10308333silvans
simians959203simians
sirens65318153s_irens
sirrahs10377303sirrahs
sirras63814863sirra_s
skeans104512913s_keans
slogans8407983slogans
slovens10316573slov_ens
soaks95220293so__aks
soaps75120713so__aps
soarers74118093soarers
soaring83521893soaring
soarings93210393soarings
soars54732513so__ars
sobas74424253so_ba_s
socas74026183so_ca_s
socials999633socials
socman1039813socman_
sodas64123543so_da_s
soddens9348413soddens
sofars94712783so_fars
sofas85320713so_fa_s
softas94410403softa_s
softens10347623softens
soirees72411643soirees
sojas124716393so_ja_s
solan55328153so_lan_
soland75115043so_land
solands84412343so_lands
solano65314183so_lano
solanos74412853so_lanos
soldan73511853soldan_
solions7513753solions
solons65120023so_lons
soman75024903so_man_
somas76030373so_ma_s
sonant6621953so_nant
sonants7511233so_nants
sonars64818973so_nars
sonorant8411703sonorant
sonorants947083sonorants
sons46049553so___ns
sora45746913so_ra__
sorbs75022103so_r_bs
sords64527803so_r_ds
sorels63921163so_rels
sores55454283so_r_es
sorgos74514663so_rgos
soring74731883so_ring
sorings83817253so_rings
sorn46641063so_r_n_
sorrels7310723sorrels
sorrows10278403sorrows
sorts54536663so_r_ts
sorus54527583so_r_us
souaris7312333souaris
soucars938423soucars
soudan73210353soudan_
sources9312173sources
souring83219063souring
sours55230503sour__s
soutane7312063soutane
soutanes8312933soutanes
soviets1087293soviets
sovranties1343843sovranties
sowars94318013so_wars
sowcars1236013sowcars
sowens93613153so_wens
soyas84520913so_ya_s
soybeans1343283soybeans
sozins15510793so_zins
spans74528733s__pans
speans85417143s_peans
spirals93212513spirals
spirant9814293spirant
spirants1088283spirants
sporran936743sporran_
sprags95715823s_prags
sprains93013593s_prains
sprang95713523s_prang
sprangs104610053s_prangs
sprats85819933s_prats
sprays115913643s_prays
spurns84811383spur_ns
sterns64616763ster_ns
strains74218153s_trains
strand74514823s_trand
strands83711953s_trands
strang75718313s_trang
straps87721783s_traps
strass67117223s_trass
straws98718673s_traws
strays96417933s_trays
suldans8299723suldans
sultans72411833sultans
sunrays1037083sunrays
suntans72111733suntans
surahs94515543s_urahs
suras55336333s_ura_s
surras65919533surra_s
sutras64818593sutra_s
swans84625013s__wans
sylvans13235893sylvans
syrens94911993s_yrens
tolans64319273to_lans
tomans85419133to_mans
torahs95115643to_rahs
toras55540373to_ra_s
toucans937583toucans
trans54933043__trans
vans76236733__v_ans
vouvrays1741373vouvrays
womans114613653wo_mans
wovens12449833wov_ens

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340272627.14318763.4
3Display Results2622620.0932817.2
 (SQL Overall)1786912627.64223382.8
 
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.