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

175 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
roset5594524(None) 
coset75748841coset
reset55051861reset
rose46148901rose_
rosed65930341rosed
roses56445771roses
rosets65819951rosets
arose55832082arose_
asset55932262asset
avoset9315672avoset
beset76739132beset
bosket124919222bosket
brose75227032brose_
broses86524402broses
closet85226602closet
comet95946072comet
corset85636222corset
cosec96320182cosec
coses76949492coses
cosets85824402cosets
cosey106226712cosey
cosset84125862cosset
cost68057942cos_t
covet105638942covet
cruset84425092cruset
doest65829522doest
dose56442432dose_
dosed76626912dosed
doser66228562doser
doses65938502doses
dost57248352dos_t
erose55727272erose_
eroses65327052eroses
frost84727832fros_t
godet7530042godet
hose76547242hose_
hosed95830982hosed
hosel86024812hosel
hosen85623882hosen
hoser811529762hoser
hoses85443172hoses
hosey116127022hosey
host77852832hos_t
inset54430862inset
lose45144582lose_
losel54419422losel
loser54728672loser
loses56742012loses
lost47951492los_t
mosey105922872mosey
most66554202mos_t
moste75925082moste
motet75641192motet
nonet54540842nonet
nose46739362nose_
nosed65524552nosed
noses55435642noses
nosey85619882nosey
onset54730172onset
ose38147342_ose_
oses46641512_oses
poet65552902po_et
pose66441732pose_
posed85828412posed
poser75128772poser
poses74642762poses
posit75833332posit
posset84923252posset
post67953362pos_t
preset84430982preset
projet15315182projet
prose75835122prose_
prosect11313392prosect
prosed94921092prosed
proser84223462proser
proses84733472proses
prosit85124592prosit
prost75434102pros_t
ramet75743142ramet
rase46149982rase_
rased65033932rased
raser55633412raser
rases55447212rases
reest54938092reest
relet54749822relet
remet74843722remet
resat55139682resat
reseat64131492reseat
resect84424702resect
resee54336332resee
resent63833622resent
resets65427612resets
resew84519502resew
resit54241042resit
rest46459842res_t
ret35982832r__et
revet84938842revet
rewet85135152rewet
rise45945232rise_
risen54621882risen
riser55431052riser
rises55244042rises
rivet85636362rivet
roast56230142roast
robe65335642robe_
robed85323732robed
robes75133302robes
robot7325972robot
rochet115423002rochet
rocket125425282rocket
rode55844302rode_
rodent7519242rodent
rodeo65921092rodeo
rodes614039082rodes
roe36861072ro_e_
roes45954132ro_es
roger64521412roger
role45851822role_
roles56747982roles
romeo73719702romeo
roose56127092roose_
roosed75621592roosed
rooser63921882rooser
rooses65526232rooses
roost55730932roost
root45655922ro_ot
rope65542912rope_
roped84630802roped
roper75431912roper
ropes75940062ropes
ropey106021872ropey
roquet154415892roquet
roseate7613452roseate
rosery93813282rosery
rosette7310372rosette
roshi8310752roshi
rosier64221262rosier
rosiest73919212rosiest
rosin55325312rosin
roster64329082roster
rosy76024872ros_y
rot37282952ro__t
rote46249022rote_
rotes56143902rotes
rotte54625932rotte
roue45941742roue_
rouen54920902rouen
roues56039352roues
roupet84218342roupet
rouse56634702rouse_
roused75426442roused
rouser65224082rouser
rouses65436282rouses
roust55532062roust
rout46153282ro_ut
route55132072route
rove75136982rove_
roved95323552roved
roven85521972roven
rover85527372rover
roves84834482roves
rowed94034322rowed
rowel84721412rowel
rowen84921152rowen
rower85430492rower
ruse45938932ruse_
ruses56136582ruses
russet6319432russet
rust45544912rus_t
set36681252__set
tost48351922tos_t
unset54532432unset
upset73222592upset
worset96726582worset
wost76544362wos_t

Search took 4 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 Limit538001753.42015731.0
3Display Results1751750.0931881.7
 (SQL Overall)1786911753.60649553.8
 
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.