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

153 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
solan5532815(None) 
sola45541861sola_
soland75115041soland
solano65314181solano
solans64122491solans
solar55927341solar
soldan73511851soldan
solon55026131solon
soman75024901soman
tolan55124011tolan
alan46844082_alan
bogan87519002bogan
bola66035562bola_
bolar75123472bolar
bolas74733762bolas
clan65633922_clan
cola66541392cola_
colas75436772colas
colin76231692colin
colon78630192colon
cotan71521782cotan
dolman95312402dolman
elan46734242_elan
eolian6312592eolian
flan76134182_flan
goban84414072goban
gowan95415742gowan
hogan97817702hogan
honan85319772honan
koan85425032ko_an
kola85124962kola_
kolas94822232kolas
loan47436452lo_an
logan68123282logan
loran55925092loran
moan65832022mo_an
mola66035632mola_
molal75120342molal
molar75223092molar
molas75132092molas
plan65833942_plan
polar75623452polar
prolan8414692prolan
roan47234202ro_an
roman75424822roman
rowan85418732rowan
salad65321832salad
salal55425702salal
salon55228552salon
saran53730302saran
scan65530452s_can
sedan65620422sedan
selah8319612selah
sewan85921292sewan
shoran94016042shoran
silane62718052silane
silvan92810152silvan
skean94415622skean
slab67133762s_lab
slag55934352s_lag
slain54923572s_lain
slam67737972s_lam
slang66324022s_lang
slank95822772s_lank
slant55238702s_lant
slap66434042s_lap
slat46959022s_lat
slaw77930712s_law
slay76436382s_lay
slogan7539222slogan
soak87227662so_ak
soap65831132so_ap
soar46838672so_ar
soba64927922soba_
sobas74424252sobas
soca66330052soca_
socas74026182socas
socman1039812socman
soda56329382soda_
sodas64123542sodas
sofa75625602sofa_
sofar86115492sofar
sofas85320712sofas
soja115619512soja_
sojas124716392sojas
sol37256622sol__
solace83415822solace
solands84412342solands
solanin7311942solanin
solanos74412852solanos
solanum946402solanum
solate64526072solate
sold54837412sol_d
soldans83210402soldans
soldi65717202soldi
soldo67116562soldo
sole46053672sol_e
soled65835172soled
solei55624342solei
solemn838642solemn
soles55547922soles
soli46637012sol_i
solid65025082solid
soling74226822soling
solion6616382solion
solo45538942sol_o
solons65120022solons
solos54830792solos
sols45448162sol_s
solum74717612solum
solus54726982solus
solve85618942solve
soma65635292soma_
somans84619302somans
somas76030372somas
son37761952so__n
sonant6621952sonant
sonar56523422sonar
soon46240502so_on
sora45746912sora_
soras55041012soras
sorn46641062so_rn
soudan73210352soudan
sovran937152sovran
sowans94215892sowans
sowar85821342sowar
sown75127452so_wn
soya75724432soya_
soyas84520912soyas
sozin14514542sozin
span65234662s_pan
spean74620512spean
splat76129342splat
splay105816042splay
stolen64315062stolen
stolon64112072stolon
suldan72611042suldan
sultan63012592sultan
swan76631312s_wan
sylvan12257362sylvan
tola45236332tola_
tolane64316582tolane
tolans64319272tolans
tolar55524112tolar
tolas54532772tolas
toman75724052toman
uhlan849112uhlan
ulan46527392_ulan
volant9316322volant
volar86917412volar
woman105818002woman
xylan1537462xylan
yulan8411492yulan

Search took 2 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.313570897.8
2DLD Change Limit538001531.45337026.8
3Display Results1531530.0463326.1
 (SQL Overall)1786911531.81298615.3
 
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.