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

224 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
soleret732123(None) 
solerets839691solerets
solleret8512221solleret
sleet55639132s_le_et
sobered102912432sobered
soberer93110352soberer
soberest10310352soberest
soldered1038152soldered
solderer947182solderer
sollerets945252sollerets
somerset10411072somerset
alert54740653_aler_t
ashlered1244623ashlered
beret74946363__beret
bolero8412093boler_o
boleros9310293boleros
bolete8519613bolete_
boletes9316063boletes
boneset9316433boneset
bowered133113043bowered
claret84026573_claret
coerect11913353co_erect
coffret15310073coffret
cohere112716993cohere_
cohered133514693cohered
coherent13412473coherent
coherer122912783coherer
coheres122917693coheres
collaret103116703collaret
collet84030363col_let
colored10313473colored
colorer9312523colorer
colure8314153colure_
colures9315133colures
covered133315293covered
coverer123113523coverer
coverlet13413013coverlet
covert114925503cover_t
cowered133214643cowered
dolerite9611773dolerite
dosseret91111513dosseret
dowered122811553dowered
fleet85932333_fle_et
floret9321123_floret
floweret1448083floweret
galere73716673galere_
galeres83514323galeres
gleet65532343_gle_et
gomerel1036393gomerel
hollered1237603hollered
homered133212713homered
hovered143411573hovered
hoverer13319823hoverer
leet45957903__le_et
leveret103014003leveret
lowered112711913lowered
moldered1237173moldered
molest85022743mole_st
oleate6318883_oleate
omelet8317073_omelet
osiered837123osiered
overbet122716063_overbet
overeat102620323_overeat
overed102216623_overed
overlet102619033_overlet
overset102821473_overset
overt85630723_over_t
overwet132013933_overwet
polecat11313143polecat
poler74431793poler__
polers84225643poler_s
pomfret1446993pomfret
powered132911643powered
rogered939553rogered
sabered103213023sabered
sallet63734543sal_let
sclera838883scler_a
sclerae937933sclerae
scleral937863scleral
scleras948223scleras
sclereid1145363sclereid
sclerite10410713sclerite
scoleces1237073scoleces
secret8325063s_ecret
select82621173sele_ct
sere46153473s__ere_
sered65737293s__ered
serer55935503s__erer
seres55448893s__eres
serest64831613s__erest
severe94016083severe_
severed113513863severed
severer103511563severer
severest11310323severest
sewered112911243sewered
sheered113515453sheered
sheerer103813843sheerer
sheerest11310083sheerest
sheet84836953s_he_et
sherbet12311383s_herbet
showered1537013showered
showerer1436163showerer
silent64125843sile_nt
silexes1438653silexes
silvered12237563silvered
silverer11216733silverer
skeet95429183s_ke_et
skirret11278163skirret
sklent103614353skle_nt
sleek94619043s_le_ek
sleep74920183s_le_ep
sleets64318873s_le_ets
sleety94112653s_le_ety
slept75728103s_le_pt
slewed104815523s_lewed
smoldered1343793smoldered
sneered83113973sneered
sneerer73512313sneerer
soared74324293so_ared
soarer64522243so_arer
sobeit8315343sobe_it
sober74822403sober__
soberly1236943soberly
sobers85218853sober_s
socket123923523so_cket
soever94412093so_ever
soilure736233soilure_
soilures836493soilures
soiree62919483so_iree
soirees72411643soirees
sokemen1337053sokemen
solace83415823solace_
solaced102911063solaced
solacer93011103solacer
solaces93116133solaces
solar55927343solar__
solaria7312493solaria
solate64526073solate_
solated83618023solated
solates73523853solates
solder73921343sol_der
solderers1066533solderers
solders83517773solder_s
soldier82812153soldier
soldiered1143763soldiered
sole46053673sol__e_
solecist10910783solecist
soled65835173sol__ed
solei55624333sol__ei
soleless8910033soleless
solely93714213sole_ly
solemn838643sole_mn
solemner1045053solemner
solemnest1148053solemnest
soleness8814263soleness
soleprint1147093soleprint
soles55547923sol__es
soleus64615613sole_us
soleuses838073soleuses
solfege1144223solfege_
solfeges1244083solfeges
solgel737963sol_gel
solicit9315743solicit
solider82912453solider
solidest9310383solidest
soloed74515743sol_oed
soloist7915893soloist
solonets838233solonets
solonetz1744853solonetz
solute64016663solute_
solutes73515263solutes
solvate102710213solvate
solve85618943sol_ve_
solved105312933sol_ved
solvent10310833solvent
solver94016703sol_ver
solvers104414253solver_s
solves95018223sol_ves
sombre10729473sombre_
somersets1144253somersets
sonnet65923503so_nnet
sorbet83924073so_rbet
sorcerer1036433sorcerer
sore47059533so__re_
sored66141783so__red
sorel56231443so__rel
sorer56236573so__rer
sores55454283so__res
sorest65027993sore_st
sorrel6413543so_rrel
sort46264813so__r_t
soured74921863so_ured
sourer63620213so_urer
sourest7515713sourest
soviet9720153so_viet
sower85229313sower__
sowers94923433sower_s
speered103614813speered
sphere113313653sphere_
sphered133512313sphered
spheres123114353spheres
spiered104412463spiered
spleen8310263sple_en
splent84720193sple_nt
splore81611303splore_
splores91910943splores
steered83615253steered
steerer73113633steerer
stere55328543s_tere_
stereo65317913s_tereo
steres63929533s_teres
sterlet71318473s_terlet
street64125773stre_et
suberect12410873suberect
sulfuret1149273sulfuret
supered10316123supered
superjet17411783superjet
sweet85330523s_we_et
tolerant8411463tolerant
tolerate8312323tolerate
towered112911403towered
velveret1447043velveret
voleries11313233voleries
volery1237873voler_y

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272246.59320328.7
3Display Results2242240.0802800.0
 (SQL Overall)1786912246.82926166.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.