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

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
roselles831071(None) 
roselle7310241roselle_
morelles10710492morelles
reseller83412252reseller
resellers9299932resellers
resells73313202resell_s
rondelles1046622rondelles
roseolas8107172roseolas
roseries8317312roseries
rosettes8310342rosettes
rouilles837182rouilles
rowelled1236632rowelled
selles64426982__selles
belles85325993__belles
boulles93114123bo_ulles
bowelled1446183bowelled
bowelless1443833bowelless
cadelles1139973cadelles
cordelles1248233cordelles
crenelles1146733crenelles
dowelled1356343dowelled
duxelles1643963duxelles
echelles1346673echelles
folles93820473fo__lles
foveoles1496643foveoles
gabelles11278933gabelles
gazelles18266563gazelles
gospeller1263753gospeller
gospellers1363023gospellers
grovelled1454183grovelled
groveller1354233groveller
grovellers1443323grovellers
hosels94218613hose_l_s
hostelled1345733hostelled
hosteller1245863hosteller
hostellers1344683hostellers
hostiles11312213hostiles
houselled1346203houselled
hovelled15146843hovelled
jostles143411143jos_tles
losels64714593lose_l_s
lovelies1139893lovelies
micelles1288833micelles
modelled1236433modelled
modeller1136613modeller
modellers1245393modellers
morelle91210803morelle_
morellos10136953morellos
morselled1245963morselled
nacelles1048393nacelles
nonselves1246503nonselves
noseless839513noseless
nouvelles1244453nouvelles
novellas1176343novellas
novelle1058233novelle_
ocellus935983_ocellus
oscules938123_oscules
osmoles9138363_osmoles
posoles9314883pos_oles
presells1058283presell_s
propelled1456913propelled
propeller1346623propeller
propellers1455203propellers
proselytes1544743proselytes
prostyles14157113prostyles
prunelles1145063prunelles
rassles73513923ras_sles
ravelled12419783ravelled
raveller11339263raveller
ravellers12257163ravellers
reales64934123r__eales
rebelled113110333rebelled
refelled122810173refelled
relies65036423r__elies
repelled113111593repelled
repeller103010403repeller
repellers11278883repellers
resales74724903res_ales
rescales103414573rescales
resealed92713973resealed
reseals73917673reseal_s
resees63827483rese__es
reseizes1759853reseizes
resell64215203resell__
resembles1376073resembles
reserves111011983reserves
resettles936563resettles
resiles74026543res_iles
resoles73823653res_oles
resolves113010783resolves
respelled1257073respelled
respells1056333respell_s
restyles1139193restyles
retells73211523retell_s
reveilles1245203reveilles
revelled123712743revelled
reveller112912193reveller
revellers12319513revellers
rilles64725503r__illes
risibles1035783risibles
rissoles839113rissoles
robles85321693ro__bles
rocailles1144993rocailles
roles56747983ro___les
rolled74220243ro__lled
roller63919793ro__ller
rollers73117473ro__llers
rolls55326233ro__ll_s
romeldales1371983romeldales
rondelle946813rondelle_
rootles73215633ro_otles
roperies10315763roperies
rosaries8312783rosaries
roscoes9310923ros_coes
roseate7613453roseate_
rosebays13114913rosebays
rosebuds1143183rosebuds
rosehips1344253rosehips
roselike12169183roselike
roseola777053roseol_a
roseolar894953roseolar
roses56445773ros___es
roseslug941743roseslug
roseslugs1051473roseslugs
rosets65819953rose__ts
rosette7310373rosette_
rosolios875273rosolios
rostella845493rostell_a
rostellar943973rostellar
rostellum1152833rostellum
rostellums1252213rostellums
roubles93413513ro_ubles
rouille737493rouille_
roweled11269863rowe_led
rowels94515453rowe_l_s
rubellas10136123rubellas
rustles73416413rus_tles
selle54428313__selle_
seller63824603__seller
sellers73721323__sellers
sells55134433__sell_s
selves94119613__selves
towelled1236353towelled
trowelled1344443trowelled
troweller1244563troweller
trowellers1343663trowellers
unsells73210773unsell_s
urodeles945563urode_les
urostyles12173973urostyles
yodelled1334603yodelled
yodeller1244853yodeller
yodellers1343973yodellers
zorilles1736123zorilles

Search took 8 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 Filter1786911461620.406440125.6
2DLD Change Limit1461621536.57622226.6
3Display Results1531530.0632428.6
 (SQL Overall)1786911537.04525364.2
 
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.