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

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

144 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
saran5373030(None) 
sarans64224431sarans
sarin55239251sarin
alan46844082_alan
arak86929572_arak
azan136521782_azan
barman103519702barman
barn66444642bar_n
baron78131242baron
bran65740382_bran
buran75225302buran
carat75048792carat
carman103920742carman
carn66245432car_n
daman84821162daman
darn56434622dar_n
earn46737552ear_n
farad95720672farad
furan84320012furan
gran56335012_gran
hazan173813612hazan
japan14411232japan
jawan15710382jawan
karat96837592karat
karn86129412kar_n
lagan66520342lagan
lauan55216792lauan
loran55925092loran
mara67444562mara_
maras75443282maras
mayan105616902mayan
naan47621932na_an
paean77222722paean
pagan86121162pagan
para65242172para_
parae76335702parae
parang93715512parang
paras76143042paras
parian83223962parian
partan83820562partan
pavan106518472pavan
pyran10514472pyran
ran38266612__ran
ratan53722662ratan
reran57329102reran
sabal75422482sabal
sabin74924942sabin
sabra75317852sabra_
sabras85116362sabras
sacra74516992sacra_
sacral83414412sacral
saga55331172saga_
sagas66025882sagas
sain45551292sa_in
salad65321832salad
salal55425702salal
salon55228552salon
sampan102511892sampan
sarape84817572sarape
sard55344242sar_d
sardana838642sardana
sardar73013172sardar
sards64736182sards
saree55044662saree
sarge65531132sarge
sargo65424412sargo
sari45444042sar_i
sarins63932622sarins
saris54544952saris
sark84938972sar_k
sarks96632462sarks
sarky125521782sarky
sarod65325872sarod
sarong73914872sarong
saros55238062saros
sarsar63011842sarsar
sarsen6314232sarsen
sasin54626572sasin
satang75711562satang
satay84718462satay
satin55935212satin
satrap86212552satrap
sauna54117552sauna
saurian739912saurian
savant9416042savant
savin84625082savin
sawn75428162sa_wn
scan65530452s_can
scarab10310062scarab
scrag85916172scrag
scram910621612scram
scrap97120402scrap
seaman84015902seaman
seawan94111222seawan
sedan65620422sedan
sera46141392sera_
serac75925202serac
serai56830162serai
seral56336382seral
serin55434442serin
sewan85921292sewan
shaman113314272shaman
sharn84823702shar_n
shoran94016032shoran
shrank13359122shrank
siren54525822siren
skean94415622skean
solan55328152solan
soman75024902soman
sora45746912sora_
soras55041012soras
sorn46641062sor_n
sovran937152sovran
span65234662s_pan
spartan948332spartan
spean74620512spean
sprag86418692sprag
sprain83614862sprain
sprang95713522sprang
sprat76635972sprat
spray106720062spray
strain64919572strain
strand74514822strand
strang75718312strang
strap77925262strap
straw813321292straw
stray88525572stray
sura45740292sura_
surah86823252surah
sural55931262sural
suras55336322suras
svaraj1634962svaraj
swan76631312s_wan
swaraj1636022swaraj
syren85216742syren
tarn46842722tar_n
tarpan82814292tarpan
tartan64217512tartan
tarzan152910752tarzan
vara75530882vara_
varas86028192varas
varna84516172varna
warn75239322war_n
yarn75230042yar_n

Search took 3 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 Filter178691538000.0931921408.6
2DLD Change Limit538001442.15624953.6
3Display Results1441440.0931548.4
 (SQL Overall)1786911442.34276298.5
 
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.