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

207 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
scripted1311755(None) 
scripter12137771scripter
coscripted1752922coscripted
scraped124313132scrap_ed
scrapped1556532scrapped
scribed124510642scri_bed
scried95817302scri__ed
scrieved14366202scrieved
scrimped1555312scrimped
script105717902script__
scripters13116672scripters
scripts11509372script_s
scrived134511112scri_ved
scrupled1335812scrupled
sculpted1354882sculpted
seriated92717022seriated
sprinted113411162sprinted
striated93414152striated
striped105214362strip_ed
stripped1357092stripped
unscripted1544632unscripted
accepted15105373accepted
ascribed1374693ascri_bed
astricted1247433astricted
chipped174110813_chipped
cisted95217523_c_isted
cited84421953_c_i_ted
clipped14439833_clipped
coapted123911493_coapted
compted143813523_compted
conscripted1853423conscripted
coopted123710763_coopted
crafted13419773_crafted
craped116120523_crap_ed
crapped143912623_crapped
crated94827773_cr_ated
created104323443_created
creped114115703_crep_ed
crested103416533_crested
cribbed14407663_cribbed
cricked164814283_cricked
cried84624283_cri__ed
crimped143910763_crimped
crimpled15366933_crimpled
cringed113312403_cringed
cripe95521143_crip_e_
cripes105120873_crip_es
crippled15336793_crippled
crispated1445023_crispated
crisped124010103_crisped
critter94113033_critter
cropped143812063_cropped
crusted103712753_crusted
decrypted1842763decrypted
drifted12367953_drifted
dripped13408083_dripped
eclipsed1343473eclipsed
encrypted1743183encrypted
erupted10207163_erupted
fritted113611333_fritted
grifted12379583_grifted
griped104114713_grip_ed
gripped13419343_gripped
gritted94110903_gritted
irrupted1143123irrupted
lariated91212063lariated
merited10313853meri_ted
muriated1139793muriated
peripter1278753peripter
printed104016373_printed
receipted1445333receipted
rifted104115313__rifted
rioted73416373__rioted
riped85226433__rip_ed
ripped114419013__ripped
sainted84114243s_ainted
satiated9311603satiated
scalped124411993scalp_ed
scamped144711963scamp_ed
scanted104114393sc_anted
scaped115519553sc_ap_ed
scarified1547293scarified
scarped124314393scarp_ed
scarphed1635433scarphed
scarted104816123sc_arted
scatted103512773sc_atted
scented102811883sc_ented
scepter1138353sc_epter
sceptred1343653sc_eptred
scooped124611743scoop_ed
scooted103612273sc_ooted
scoped115116653sc_op_ed
scorified1546183scorified
scouted104112033sc_outed
scragged1335813scragged
scraiched1744203scraiched
scraighed1643593scraighed
scrammed1555003scrammed
scrape105917573scrap_e_
scraper114513403scrap_er
scrapes116217663scrap_es
scrapie115010943scrapie_
scrapies124612473scrapies
scrapper1466953scrapper
scrawled1445903scrawled
screaked15246973screaked
screamed13277593screamed
screed95718923scr__eed
screeded1235633screeded
screened1137403screened
screwed135710653scr_ewed
scribbled16174033scribbled
scribe104613533scri_be_
scriber113910963scri_ber
scribes113713203scri_bes
scries85226823scri__es
scrieve12448333scrieve_
scrieves13387613scrieves
scrimper1455753scrimper
scrimpier1554243scrimpier
scrip96619193scrip___
scrips105316033scrip__s
scripting1437473scripting
scripture1343873scripture
scriptures1443793scriptures
scrive115414943scri_ve_
scrives124414273scri_ves
scrolled1137043scrolled
scrooped1356403scrooped
scrouged1235373scrouged
scrubbed1533853scrubbed
scrummed1554313scrummed
scruple1137193scruple_
scruples1237433scruples
sculped12398253sculp_ed
secreted1138633secr_eted
seriate73722473seriate_
seriates82620663seriates
serifed11811463seri_fed
seriffed1594973seriffed
serrated92513423serrated
shifted14359973s_hifted
shipped153312103s_hipped
shitted114212043s_hitted
shrieked16265173shrieked
shrieved15276073shrieved
shrilled1246863shrilled
shrimped1634213shrimped
shrined114112413shri_ned
shrived144712183shri_ved
sifted104313673s__ifted
silted74020013s__ilted
siped84927683s__ip_ed
sipped113720633s__ipped
siruped1036013sirup_ed
sited65130743s__i_ted
skipped16358403s_kipped
skirted12388613s_kirted
skited114313473s_ki_ted
sliped95417063s_lip_ed
slipped124711743s_lipped
slitted83513313s_litted
sniped94913483s_nip_ed
snipped123510043s_nipped
sopited104211053sopi_ted
sorites73825243sori_tes
sorted74523713sor__ted
spirited1148963spirited
spirted103913073s_pirted
spited94820443s_pi_ted
spitted103912703s_pitted
splinted11369253splinted
sprigged13316213sprigged
springed123911313springed
sprinter103810813sprinter
sprite84421773spri_te_
sprites94220333spri_tes
spritzed2044783spritzed
sprouted1136383sprouted
squinted1847053squinted
squirted1845783squirted
stilted83511473s_tilted
stinted82914193s_tinted
stiped94517073s_tip_ed
strapped1357813strapped
striate74218953striate_
striates83417083striates
stricter1039413stricter
stringed102911873stringed
stripe85822443strip_e_
striper94514783strip_er
stripes95320573strip_es
stripier1058853stripier
stripper1247113stripper
stript85222193stript__
strived114713663stri_ved
stropped1367333stropped
strunted957243strunted
strutted946343strutted
suited74019423s_ui_ted
swiped123811093s_wip_ed
syringed13377583syringed
syruped1334543syrup_ed
tripled104113833_tripled
tripped123911693_tripped
unripped1335763unripped
variated121211393variated

Search took 9 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.1561145455.1
2DLD Change Limit1461622078.00018270.3
3Display Results2072070.0762723.7
 (SQL Overall)1786912078.23221706.9
 
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.