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

131 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
sarans6422443(None) 
saran53730301saran_
sarins63932621sarins
alans55636172_alans
araks94820882_araks
azans146516882_azans
barns76335142bar_ns
barons85025382barons
brans75437432_brans
burans85019302burans
carats85929022carats
carns75937562car_ns
damans94715982damans
darns66927892dar_ns
earns55927562ear_ns
farads104713272farads
furans94515952furans
grans64832542_grans
harass9313942harass
hazans183411652hazans
japans1539822japans
jawans1657842jawans
karats106420492karats
karns96624142kar_ns
lagans75717782lagans
lauans65113532lauans
lorans65117602lorans
maras75443292mara_s
naans55815252na_ans
paeans85118262paeans
pagans95717922pagans
parang93715512parang
parangs104314372parangs
paras76143042para_s
parians93519732parians
partans94418282partans
pavans115715592pavans
pyrans11411062pyrans
ratans63819372ratans
sabals84618862sabals
sabins85521982sabins
sabras85116362sabra_s
sacrals93311792sacrals
sagas66025882saga_s
sains55639972sa_ins
salads75316962salads
salals65120082salals
salons63823692salons
sampans112411002sampans
sans45153362s__ans
sarape84817572sarape
sarapes94617742sarapes
sardana838642sardana
sardanas937812sardanas
sardars83112902sardars
sards64736182sar_ds
sarees65329942sarees
sarges75128592sarges
sargos74318272sargos
sarin55239252sarin_
saris54544952sar_is
sarks96632462sar_ks
sarods74918572sarods
sarong73914872sarong
sarongs84511802sarongs
saros55238062sar_os
sarsars73512142sarsars
sarsens7311392sarsens
sasins64923102sasins
satang75711562satang
satangs8479712satangs
satays94411682satays
satins64930482satins
satraps95011642satraps
saunas63915432saunas
saurians837762saurians
savant9416042savant
savants1038652savants
savins93923132savins
scans74625102s_cans
scarabs1137292scarabs
scrags95713802scrags
scrams105216622scrams
scraps106017242scraps
seawans10379942seawans
sedans74816092sedans
seracs84418572seracs
serais64326132serais
serins64029672serins
sewans95215902sewans
shamans123610902shamans
sharns95516982shar_ns
shorans102812412shorans
shrank13359122shrank
sirens65318152sirens
skeans104512912skeans
solans64122492solans
somans84619302somans
soras55041012sora_s
sorns55028422sor_ns
sovrans1036482sovrans
sowans94215892sowans
spans74528732s_pans
speans85417142speans
sprags95715822sprags
sprains93013592sprains
sprang95713522sprang
sprangs104610052sprangs
sprats85819932sprats
sprays115913642sprays
strains74218152strains
strand74514822strand
strands83711952strands
strang75718312strang
straps87721782straps
strass67117222strass
straws98718672straws
strays96417932strays
surahs94515542surahs
suras55336332sura_s
swans84625012s_wans
syrens94911992syrens
tarns56433952tar_ns
tarpans92513532tarpans
tartans72615822tartans
tarzans16329922tarzans
trans54933042_trans
varas86028192vara_s
varnas94212822varnas
warns87231002war_ns
yarns85621792yar_ns

Search took 4 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 Filter178691825510.343520965.0
2DLD Change Limit825511312.84329036.6
3Display Results1311310.0462847.8
 (SQL Overall)1786911313.23255288.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.