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

219 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
svaraj163496(None) 
swaraj1636021swaraj
saran53730302s_aran
scarab10310062scarab
svarajes1843512svarajes
vara75530882_vara_
varas86028192_varas
arak86929573__arak
avatar937523avatar
bharal1138893bharal
carat75048793_carat
charas114223593charas
farad95720673_farad
karat96837593_karat
mara67444563_mara_
maras75443283_maras
ovarial1037613ovarial
ovarian1037643ovarian
ovary1149113ovar_y
para65242173_para_
parae76335703_parae
paras76143043_paras
raj105740223___raj
sabal75422483s_abal
sabra75317853sabra_
sabras85116363sabras
sacra74516993sacra_
sacral83414413sacral
saga55331173s_aga_
sagas66025883s_agas
salad65321833s_alad
salal55425703s_alal
samara8313853samara_
samaras9312913samaras
sarans64224433s_arans
sarape84817573s_arape
sard55344243s_ar_d
sardar73013173s_ardar
sards64736183s_ards
saree55044663s_aree
sarge65531133s_arge
sargo65424413s_argo
sari45444043s_ar_i
sarin55239253s_arin
saris54544953s_aris
sark84938973s_ar_k
sarks96632463s_arks
sarky125521783s_arky
sarod65325873s_arod
saros55238063s_aros
sarsar63011843s_arsar
satara6315533satara_
sataras7315053sataras
satay84718463s_atay
satrap86212553satrap
savarin10310003savarin
scalar83612433scalar
scar66434203scar__
scarabs1137293scarabs
scarce104013633scarce
scare75334463scar_e
scared95227293scared
scarer84524603scarer
scares85033003scares
scarey115016983scarey
scarf105427143scar_f
scarfs114714683scarfs
scarp95724103scar_p
scarph13429603scarph
scarps104718603scarps
scarry116311183scarry
scars75433533scar_s
scart76139773scar_t
scarts85321493scarts
scary105222593scar_y
scrag85916173s_crag
scram910621613s_cram
scrap97120403s_crap
seabag938473seabag
seaman84015903seaman
sear47353843sear__
search113312423search
seared75232843seared
searer65432023searer
sears54744913sear_s
seawan94111223seawan
seaway12309993seaway
sera46141393s_era_
serac75925203s_erac
serai56830163s_erai
seral56336383s_eral
several1039533several
shaman113314273shaman
shamas113717933shamas
shard96125963shar_d
shards104319173shards
share86437083shar_e
shared105829063shared
sharer95025483sharer
shares95236413shares
sharia93116723sharia
shariah132210533shariah
sharias102516003sharias
sharif122917113sharif
shark126225023shar_k
sharks135019723sharks
sharn84823703shar_n
sharns95516983sharns
sharny124711833sharny
sharp104922533shar_p
sharps115516083sharps
sharpy145211033sharpy
shazam2046603shazam
shoran94016033shoran
sirra54416323sirra_
sirrah9379753sirrah
sirras63814863sirras
smaragd1134393smaragd
smarm95517603smar_m
smarms105712533smarms
smarmy13629353smarmy
smart75834093smar_t
smarts86218003smarts
smarty115013793smarty
snare54429983snar_e
snared74824553snared
snarer64620843snarer
snares65329033snares
snarf86525423snar_f
snarfs95113423snarfs
snark95419943snar_k
snarks104815733snarks
snarky134210843snarky
snarl54921083snar_l
snarls64016873snarls
snarly93815003snarly
soar46838673soar__
soared74324293soared
soarer64522243soarer
soars54732513soar_s
sora45746913s_ora_
soras55041013s_oras
sovran937153sovran
spar65433303spar__
spare75135563spar_e
spared95427483spared
sparer84524963sparer
spares84834553spares
sparge94216043sparge
sparid94016933sparid
spark114920893spar_k
sparks124616363sparks
sparky154511523sparky
sparry115111303sparry
spars75431543spar_s
sparse84516343sparse
spartan948333spartan
spiral83715343spiral
sporal82915453sporal
sprag86418693s_prag
sprat76635973s_prat
spray106720063s_pray
stalag7310023stalag
star48037763star__
starch113013203starch
stare54440263star_e
stared75429873stared
starer64027363starer
stares66038753stares
stark95425623star_k
starry94911673starry
stars55836573star_s
start55642313star_t
starts65423123starts
starve94613743starve
statal61613223statal
storax1389783storax
strap77925263s_trap
straw813321293s_traw
stray88525573s_tray
styrax1675243styrax
sunray9310123sunray
supra73614253supra_
sura45740293s_ura_
surah86823253s_urah
sural55931263s_ural
suras55336323s_uras
surra55521343surra_
surras65919533surras
sutra54217933sutra_
sutras64818583sutras
swarajes1843743swarajes
sward94221463swar_d
swards105415133swards
sware85828213swar_e
swarf115324653swar_f
swarfs125612063swarfs
swarm106218833swar_m
swarms116112163swarms
swart86234643swar_t
swarth126012083swarth
swarty125812383swarty
tiara5315903tiara_
tiaras6314533tiaras
vagal94613633_vagal
var66148333_var__
varia85824203_varia
varias95019903_varias
varix154313503_varix
varna84516173_varna
varnas94212823_varnas
vars75742073_var_s
varus85921183_varus
varve115716853_varve
vary105226063_var_y
vasa76522973_vasa_
vasal85516293_vasal
vera76828843_vera_
viral86419593_viral

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 Limit1127162196.54617219.1
3Display Results2192190.0633476.2
 (SQL Overall)1786912196.74926476.7
 
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.