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

213 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
solus5472698(None) 
bolus79125541bolus
soles55547921soles
soleus64615611soleus
solos54830791solos
sols45448161sol_s
solum74717601solum
solums85211331solums
sorus54527581sorus
souls55127361souls
sous46947211so_us
sulus54821881sulus
tolus55024481tolus
bogus85616472bogus
bolas74733762bolas
bolds85825282bolds
boles75448602boles
bolls75531312bolls
bolos75531372bolos
bolts76232112bolts
bonus75324322bonus
colas75436772colas
colds85726972colds
coles76055062coles
coleus86818272coleus
cols66553082col_s
colts76633292colts
conus76726532conus
doles67843752doles
dolls66126922dolls
dols56943052dol_s
dolts65626312dolts
flus75626542_flus
focus105815882focus
folds95221692folds
folks126017122folks
fouls87221432fouls
golds75421312golds
golfs95616102golfs
hilus84817642hilus
hocus104715202hocus
holds94623242holds
holes84748652holes
holks124720562holks
holms105117802holms
hols76946292hol_s
holts85627912holts
iglus6609932iglus
joles125230832joles
jolts125018882jolts
kolas94822232kolas
kolos94921212kolos
locus74819992locus
lolls512121732lolls
lotus55718062lotus
lulus54315162lulus
modus85417202modus
molas75132092molas
molds85324832molds
moles74747922moles
molls75129782molls
mols65948572mol_s
molts76032092molts
momus96116112momus
nodus66315992nodus
nolos54423352nolos
nous46136982no_us
obolus8378812obolus
olds55926572_olds
oles46453472_oles
onus45826812_onus
opus66420592_opus
pilus75921062pilus
plus66324832_plus
poilus82210572poilus
poles75351002poles
polis74731162polis
polls74627722polls
polos76129912polos
pols66044562pol_s
polys105718762polys
roles56747982roles
rolfs84817122rolfs
rolls55326232rolls
sales56055592sales
salps74423242salps
sals46851672sal_s
salts55431882salts
sauls55128122sauls
scolds95011232scolds
selfs85220242selfs
sells55134432sells
sels46345982sel_s
shlub105411742shlub
shlubs11386732shlubs
shoyus1265992shoyus
shuls85319712shuls
silds65520522silds
silks94620682silks
sills55135982sills
silos56029422silos
silts55330822silts
sinus55523852sinus
situs55019232situs
slobs74419872slobs
sloes54728872sloes
slogs64521842slogs
slops75026012slops
slots54830522slots
slows85323462slows
slub65428032s_lub
slubs74719532s_lubs
slue45332192s_lue
slues54527172s_lues
slug55124642s_lug
slugs64618562s_lugs
slum65430512s_lum
slums74623432s_lums
slur45525152s_lur
slurs54123372s_lurs
slush85316572s_lush
slut45040592s_lut
sluts54523982s_luts
smolts84411882smolts
soaks95220292soaks
soaps75120712soaps
soars54732512soars
sobas74424252sobas
sobs64941752so_bs
socas74026182socas
socks114926082socks
socles8418452socles
sodas64123542sodas
sods54940212so_ds
sofas85320712sofas
softs85019232softs
soils55327982soils
sojas124716392sojas
sokes95031422sokes
sol37256622sol__
sola45541862sol_a
solan55328152solan
solans64122492solans
solar55927342solar
sold54837412sol_d
soldi65717192soldi
soldo67116562soldo
sole46053672sol_e
soled65835172soled
solei55624332solei
soli46637002sol_i
solid65025072solid
solids74116402solids
solidus8338112solidus
solo45538942sol_o
solon55026132solon
solons65120012solons
solute64016662solute
solutes73515262solutes
solve85618942solve
solves95018222solves
somas76030372somas
soms66239372so_ms
sones55444142sones
songs67725552songs
sons46049552so_ns
sooks94425452sooks
soots55536202soots
sophs104916022sophs
sops65244562so_ps
soras55041012soras
sorbs75022102sorbs
sords64527802sords
sores55454282sores
sorns55028412sorns
sorts54536662sorts
sos37761602so__s
soths86218622soths
sots45552442so_ts
sou37853692so_u_
souk86127172so_uk
souks94820522souks
soul46435712so_ul
soup66232912so_up
soups75322942soups
sour45935892so_ur
sours55230502sours
souse56530772so_use
sows75342492so_ws
soyas84520912soyas
soys75233932so_ys
soyuz1748852soyuz
stoles63927672stoles
stylus9397462stylus
sulcus8410492sulcus
sulks94818462sulks
sulu45128422sulu_
sylis84316022sylis
talus55423262talus
tofus86415422tofus
tolas54532772tolas
toles55147132toles
tolls54728432tolls
tolu45529152tolu_
tonus56324302tonus
torus54329762torus
ulus45622562_ulus
voles86234042voles
volts85421292volts
wolds95420182wolds
wolfs116214162wolfs
yolks125412772yolks
yous76230652yo_us

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.0762351197.4
2DLD Change Limit538002131.72031279.1
3Display Results2132130.0603550.0
 (SQL Overall)1786912131.85696277.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.