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

182 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
sorel5623144(None) 
morel75729091morel
sore47059531sore_
sored66141781sored
sorels63921161sorels
sorely94618001sorely
sorer56236571sorer
sores55454281sores
sorrel6413541sorrel
boral75831702boral
bordel94514572bordel
bore66051332bore_
boreal84817212boreal
bored85034302bored
borer75131272borer
bores76448252bores
botel75121862botel
bowel105621202bowel
coral76033452coral
corbel103715972corbel
core67263112core_
cored85044222cored
corer75538872corer
cores76361852cores
cormel103815602cormel
cornel84020052cornel
dore56353302dore_
dorsel75315502dorsel
dowel95618192dowel
fore78351472fore_
fores85847102fores
goral65125752goral
gore55744962gore_
gored75227082gored
gores65740372gores
horal86328672horal
hosel86024812hosel
hotel85520742hotel
hovel115017682hovel
isohel935482isohel
jurel124516332jurel
koel84519942ko_el
kore85834162kore_
loral55927822loral
lore45850352lore_
loreal63814312loreal
lores55045402lores
losel54419422losel
model84521692model
mohel104914832mohel
moral75533432moral
more67154522more_
morels84820012morels
mores76249642mores
morsel85815892morsel
motel76623242motel
noel45226552no_el
novel85615992novel
oral47638122_oral
ore36661832_ore_
ores46056682_ores
oriel54920422_oriel
orle45630462_orle
pore66451262pore_
pored85234512pored
pores75849032pores
rowel84721412rowel
saree55044662saree
saurel6511982saurel
score75526732score_
scored94621132scored
scorer84818252scorer
scores84725922scores
scree720031702scree
screw109318532screw
seel45042982s_eel
sel38253322s__el
seral56336382seral
sere46153472sere_
sered65737292sered
serer55935502serer
seres55448892seres
shiel811023772shiel
shore85432642shore_
shored105723642shored
shores94830402shores
shorl84720242shor_l
shovel124611312shovel
shred98125612shred
shrew119720162shrew
sire46150412sire_
sired66134282sired
siree55238812siree
siren54525822siren
sires55945372sires
snore55424952snore_
snored74819542snored
snorer64316762snorer
snores64324312snores
snorkel1135422snorkel
soared74324292soared
soarer64522242soarer
sober74822402sober
socle7419572socle
soil46138822so_il
soiree62919482soiree
soke85436262soke_
sokes95031422sokes
sokol94612282sokol
sol37256622so__l
sole46053672sole_
soled65835172soled
solei55624332solei
solely93714212solely
soles55547922soles
solgel737962solgel
some66040382some_
sone46649982sone_
sones55444142sones
sooey84522432sooey
sora45746912sor_a
soras55041012soras
sorb68333042sor_b
sorbed94916512sorbed
sorbet83924072sorbet
sorbs75022102sorbs
sord56237202sor_d
sords64527802sords
sorest65027992sorest
sorgo64719722sorgo
sori46039832sor_i
sorn46641062sor_n
sorned74820042sorned
sorner64720382sorner
sorns55028412sorns
sorrels7310712sorrels
sorry84618252sorry
sort46264812sor_t
sorta57125412sorta
sorted74523712sorted
sorter64425082sorter
sorts54536662sorts
sorus54527582sorus
sotol54917642sotol
soul46435712so_ul
soured74921862soured
sourer63620212sourer
sowed94933862sowed
sower85229312sower
speel74420762speel
spiel74623912spiel
sporal82915452sporal
spore75428592spore_
spored94821792spored
spores84726612spores
spree74830862spree
steel55721992steel
store56333812store_
stored75524212stored
storer64721672storer
stores65533642stores
storey95217612storey
streel64214022streel
strep77120852strep
strew89220652strew
sural55931262sural
sure45447412sure_
surely93816452surely
surer54833092surer
swore84920812swore_
syren85216742syren
tore47359322tore_
tores55352672tores
towel84920522towel
tsores65113662tsores
vowel115515012vowel
wore77144672wore_
yodel94714082yodel
yokel124812612yokel
yore76335942yore_
yores85031322yores
zoril143916692zoril

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.0931921408.6
2DLD Change Limit538001821.61033416.1
3Display Results1821820.0463956.5
 (SQL Overall)1786911821.749102167.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.