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

195 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
speedos1029826(None) 
speedo94011991speedo_
speeds94316051speed_s
pseudos1044832pseudos
seeds64330062s_eed_s
speed85526622speed__
speeded113310422speeded
speeder103811072speeder
speeders11339312speeders
speedup1272982speedup
speedups1342232speedups
speedy1218410782speed_y
speels85116392spee_ls
speers85019952spee_rs
spends94714472spend_s
steeds73814882steed_s
albedos1075253albedos
bleeds95211593bleed_s
breeds94914883breed_s
cheeros123711633cheeros
comedos12329073comedos
credos94612843_credos
creeds94714773creed_s
deeds75423763_deed_s
eidos65817753__eidos
epees75219833epee__s
ephebos1444113ephebos
feeds94921143_feed_s
freedom1345853freedom
freedoms1445433freedoms
gleeds84711623gleed_s
greeds84314283greed_s
heeds95420423_heed_s
kendos114510663_kendos
meeds84920273_meed_s
needs65719633_need_s
pedes85327283_p_edes
pedros9312183_pedros
peds75835243_p_ed_s
peed76239183_peed__
peeks115021113_pee_ks
peels75226423_pee_ls
peens76428193_pee_ns
peeps95822363_pee_ps
peers75130273_pee_rs
pees65257373_pee__s
peeves113814873_peeves
pends85527193_pend_s
pengos94612413_pengos
peplos101211543_peplos
pepos96620083_p_epos
perdus93711273_perdus
pesos77221623_p_esos
pestos84719083_pestos
pseudo934713pseudo_
pseuds944793pseud_s
redos65126763__redos
reeds65430903_reed_s
reredos838633reredos
sayeds10469253sayed_s
scends95213003scend_s
screeds106210283screed_s
seadog838743s_eadog
seadogs958643s_eadogs
seccos1039923s_eccos
secedes103711983secedes
seders74420283s_eders
seed55549483s_eed__
seeded84520463s_eeded
seeder74320773s_eeder
seeders83017113s_eeders
seedpod1144013s_eedpod
seedpods1243843s_eedpods
seedy94821533s_eed_y
seeks94724643s_ee_ks
seels55632823s_ee_ls
seems75525023s_ee_ms
seeps74828753s_ee_ps
seers55136383s_ee_rs
sees45361053s_ee__s
segnos73610443s_egnos
segos64919483s__egos
seldom939403s_eldom
sends65528243s_end_s
servos93812723s_ervos
sextos134012163s_extos
sheds96122703s_hed_s
sheens95116993shee_ns
sheepdog1542363sheepdog
sheepdogs1642223sheepdogs
sheers94322403shee_rs
sheets93918493shee_ts
sheeves133911953sheeves
shends105313773shend_s
sherds105614723sherd_s
shreds105613053shred_s
skeed105018983skeed__
skeens103912913skee_ns
skees95023123skee__s
skeets104513253skee_ts
sleds64418853s_led_s
sleeks104512463slee_ks
sleeps83913323slee_ps
sleets64318873slee_ts
sleeves103311343sleeves
smeeks12428433smee_ks
sneds65715353s_ned_s
sneers64016173snee_rs
sneezes16278503sneezes
spaders104214473spaders
spades94222583sp_ades
spado83713703sp_ado_
spaed85522273spaed__
spaes76029973spae__s
speaks125114583sp_eaks
speans85417143sp_eans
spears84019473sp_ears
species11314133species
specious1247483specious
specks144312703sp_ecks
specs96916673sp_e_cs
sped76031493sp_ed__
speech1347563spee_ch
speeches1537413speeches
speedboat1453363speedboat
speedboats1552203speedboats
speedier1146623speedier
speediest1257463speediest
speedily1465173speedily
speeding122810933speeding
speedings13265403speedings
speedway1743313speedway
speedways1842553speedways
speel74420763spee__l
speeled103712453speeled
speer74623903spee__r
speered103614813speered
speils84116223sp_eils
speirs85013233sp_eirs
speises93813933speises
speiss84311643sp_eiss
spells84617683sp_ells
spelts84614643sp_elts
spences113413923spences
spend85619333spend__
spender103713693spender
spenders113211743spenders
spendy124911143spend_y
spenses92913573spenses
spermous1247933spermous
sperms102512603sp_erms
spewed125512333spewed__
spewers124210653spewers
spews105015923sp_e_ws
sphenes123013163sphenes
spheres123114353spheres
spiders103914413spiders
spied85427713spied__
spiels85317953spie_ls
spiers84421743spie_rs
spies76037623spie__s
spintos939133spintos
spleens937103spleens
splendor1143743splendor
splendors1244013splendors
splents93912133splents
spodes94817433sp_odes
spreads1039763spreads
sprees85620643spre_es
spuds85113673sp_ud_s
spued84918473spued__
spues75025383spue__s
steads74116223stead_s
steed66024943steed__
steeks103613703stee_ks
steels64117983stee_ls
steeps85215193stee_ps
steers63820983stee_rs
steeves103410903steeves
stenos63915773s_tenos
stereos74314973stereos
suedes73918113s_uedes
superegos1246813superegos
supremos1245813supremos
swedes102711893s_wedes
sweeps114110513swee_ps
sweets94214433swee_ts
teredos839173teredos
toledos8388863toledos
tuxedos1543293tuxedos
tweeds10498433tweed_s
updos8389513up__dos
upends9438763upend_s
uredos73910623_uredos
weeds95222213_weed_s

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.1561145455.1
2DLD Change Limit1340271957.72017361.0
3Display Results1951950.0762565.8
 (SQL Overall)1786911957.95222471.2
 
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.