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

321 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
roscoes931092(None) 
roscoe839761roscoe_
ciscoes113610732ciscoes
frescoes1357832frescoes
locoes85516582lo_coes
rescores105415692rescores
rescues9312752rescues
reshoes102316032reshoes
roaches123616212roaches
roses56445772ros__es
rotches123515702rotches
rouches124217892rouches
aeroscopes1448013aeroscopes
ascots85312513_ascots
baroscopes1646753baroscopes
bioscopes1546553bioscopes
bocces123912023bo_cces
boccies133311513boccies
boches134618523bo_ches
bongoes104314113bongoes
boocoos1137753boocoos
borsches1536003borsches
boscages1366643boscages
boshes114721883bos_hes
bosoms104913043bos_oms
bosons85016653bos_ons
bosques18217973bosques
bosses85925403bos_ses
bossies94116833bossies
bostons9312893bostons
botches143716023botches
boucles113113003boucles
broaches153211623broaches
broncos11188073bronco_s
brooches15288193brooches
broses86524403bros__es
ciscos104711133cisco_s
coaches144018693coaches
coccous1038993coccous
cocoas104915743co_coas
cocos95624693co_co_s
conches144019813conches
condoes104319203condoes
congoes103617303congoes
cooches143515833cooches
coses76949493cos__es
coshes115022783cos_hes
cosies84932153cos_ies
cosines94122673cosines
cosmos10311753cosmo_s
cosmoses1239703cosmoses
couches144020463couches
couscous1246663couscous
crosses94220793cros_ses
crotches153411293crotches
crouches153711283crouches
cryoscopes1995253cryoscopes
discoed11312483discoed
discos94915213disco_s
dodoes85716103do_does
dosages92310803dosages
doses65938503dos__es
dosses76126273dos_ses
douches134315233douches
droskies13186343droskies
drosses84513823dros_ses
eosines73718293eosines
eroses65327053eros__es
erosions8310333erosions
escots84211743_escots
fasces114914543fasc_es
fescues1236783fescues
fiascoes13134923fiascoes
ficoes114613463_ficoes
forces114422133forc_es
fordoes11311963fordoes
forgoes11311353forgoes
fosses96022083fos_ses
frescoed1436053frescoed
frescoer1345983frescoer
frescoers1454563frescoers
frescos1236813fresco_s
fuscous1256673fuscous
gascons10289103gascons
gessoes838293gessoes
goboes95914443go_boes
groschen1442973groschen
grosses84517683gros_ses
grottoes9276753grottoes
grouches14328213grouches
gustoes879873gustoes
gyroscopes1845073gyroscopes
hoboes114717443ho_boes
holloes103818193holloes
hooches153812523hooches
hoopoes121212483hoopoes
horoscopes1747633horoscopes
hoses85443173hos__es
hotches153814363hotches
jocose1537103jo_cose
joshes165114853jos_hes
josses135117683jos_ses
jostles143411143jostles
juncoes16338073juncoes
lassoes74613853lassoes
loaches123613983loaches
locoed94312193lo_coed
locos75822603lo_co_s
loses56742013los__es
losses65925233los_ses
mascons113411583mascons
mascots113910343mascots
miscodes13310423miscodes
miscues11312393miscues
misdoes10312493misdoes
mojoes15399523mo_joes
mongoes103415713mongoes
mooches143714453mooches
moshes115222873mos_hes
mosques18256913mosques
mosses85527683mos_ses
mottoes93412193mottoes
mouches143815963mouches
muscles11310563muscles
myoscopes1845043myoscopes
nonces84418833nonc_es
noncoms1139183noncoms
noses55435643nos__es
noshes96618233nos_hes
nostocs947543nostocs
notches123513653notches
oboes75717713_o_boes
oospores1049523oospores
oraches124216473oraches
oracles93212423oracles
oscines9310363_oscines
oscules938123_oscules
oses46641513_os__es
osmoles9138363_osmoles
osmols8137313_osmols
osmose8108003_osmose
osmoses9138123_osmoses
osmous8138183_osmous
ostoses71213543_ostoses
otoscopes1346513otoscopes
ouches114322183_ouches
piscos105112593pisco_s
poaches144416943poaches
ponces104720843ponc_es
pooches143214163pooches
porches143815673porches
poses74642763pos__es
posies84431433pos_ies
posoles9314883posoles
posses85128803pos_ses
postcodes1446153postcodes
posties93128813posties
postops11311703postops
pouches144116743pouches
prescores133912173prescores
proses84733473pros__es
prosos85718553pros_o_s
prosses94019513pros_ses
prossies101515223prossies
prosties101421193prosties
races74943243r_ac_es
racons84319343r_acons
rances84625443ranc_es
ranches123620113ranches
rancors9811373rancors
rascals959663rascals
rases55447213ras__es
rashes95330153ras_hes
rassles73513923rassles
rasures7312013rasures
ratches123620463ratches
raucous938283raucous
reaches123423203reaches
recces10614913r_ecces
recodes102918633r_ecodes
recons84922993r_econs
redoes74623753r_edoes
reechoes1338413reechoes
resales74724903resales
rescales103414573rescales
rescore95616193rescore
rescored114513103rescored
rescue8313003rescue_
rescued10410043rescued
rescuer939033rescuer
rescuers1037363rescuers
resees63827483res_ees
reshes94124363res_hes
reshoe92816483reshoe_
reshoed112212153reshoed
reshows132510453reshows
resides84523283resides
resiles74026543resiles
resites74027793resites
resizes164216843resizes
resods74116303res_ods
resoles73823653resoles
resows93915353res_ows
respots92912763respots
restokes125213043restokes
restores85222983restores
resumes9313373resumes
retches123318513retches
rices75536153r_ic_es
riches115022083r_iches
rises55244043ris__es
rissoles839113rissoles
risuses73210923risuses
roached133211833roached
roadeos837403roadeos
roadies83317433roadies
robes75133303ro__bes
robles85321693ro_bles
robots8313143ro_bots
rochet115423003ro_chet
rochets124213473ro_chets
rocked135022323ro_cked
rocker124319573ro_cker
rockers133916553ro_ckers
rocket125425283ro_cket
rockets134615363ro_ckets
rocks114626413ro_c_ks
rococo1036813ro_coco
rococos1145903ro_cocos
rocs65533663ro_c__s
rodeoed937883rodeoed
rodeos75314503rodeo_s
rodes614039083ro__des
roes45954133r___oes
rogues74617673ro_gues
roles56747983ro__les
romeos84013173romeo_s
rondos74616723rondo_s
ronions73313343ronions
ronyons10258433ronyons
roods65125283ro__ods
roofies103014413roofies
roofs85321153ro__ofs
rookies113917103rookies
rooks95325043ro__oks
roomies93017243roomies
rooms75324683ro__oms
roose56127093ro__ose
rooses65526233ro_oses
rootles73215633rootles
roots55933673ro__ots
ropes75940063ro__pes
roques154912563ro_ques
rosacea944713rosacea
rosaceas1043723rosaceas
rosaceous1144233rosaceous
rosaries8312783rosaries
rose46148903ros__e_
rosed65930343ros__ed
roselles8310713roselles
roseola777053roseola
roseolas8107163roseolas
roseries8317313roseries
roset55945243ros__et
rosets65819953ros_ets
rosettes8310343rosettes
roshis9311793ros_his
rosier64221263ros_ier
rosiest73919213ros_iest
rosined84911903rosined
rosiness82613173rosiness
rosinols845673rosinols
rosinous847363rosinous
rosins64521863ros_ins
roster64329083ros_ter
rosters73727533rosters
rotates72819773rotates
rotche114311983rotche_
rotes56143903ro__tes
rotors64917933ro_tors
rotos56027883ro_to_s
rottes64524833ro_ttes
roubles93413503roubles
rouche114714313rouche_
roues56039353ro__ues
rouges76022383ro_uges
rouses65436283ro_uses
routes66129313ro_utes
roves84834483ro__ves
rowdies113112693rowdies
ruches114819583r_uches
ruses56136583rus__es
rushees103311953rushees
rushes94724363rus_hes
rustles73416413rustles
scones84521303__scones
scopes104719593__scopes
scops95820193__scops
scores84725923__scores
scots74025903__scots
scows106617803__scows
shoes85429653__shoes
sloes54728873__sloes
socles8418453so_cles
toeshoes1147713toeshoes
tomcods1234873tomcods
torches123715433torches
toshes94520103tos_hes
tosses65225393tos_ses
touches125118343touches
troches123715343tro_ches
tusches1237903tusches
uroscopies1455383uroscopies
uroscopy1544273uroscopy
viscose1237863viscose
viscoses1338343viscoses
viscous1238833viscous
voces105918053vo_c_es
voices114414013voic_es
vouches153914113vouches
yobboes1445583yobboes

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 Filter1786911340270.1531167915.0
2DLD Change Limit1340273216.76619808.9
3Display Results3213210.1102918.2
 (SQL Overall)1786913217.02925422.0
 
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.