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

445 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
scrived13451111(None) 
scribed124510641scribed
scried95817301scri_ed
scrieved14366201scrieved
scrive115414941scrive_
scrives124414271scrives
shrived144712181shrived
strived114713661strived
arrived11127352arrived
ascribed1374692ascribed
craved125417772_craved
cried84624282_cri_ed
derived123912762derived
rived94825612__rived
scraped124313132scraped
screed95718922scr_eed
screwed135710652screwed
scribe104613532scribe_
scriber113910962scriber
scribes113713202scribes
scries85226822scri_es
scrieve12448332scrieve
scrieves13387612scrieves
scrimped1555312scrimped
scripted13117552scripted
serifed11811462serifed
served104616812ser_ved
shrieved15276072shrieved
shrined114112412shrined
shrive125216952shrive_
shrivel13479402shrivel
shriven13379652shriven
shriver134712192shriver
shrives134416172shrives
skived14429892s_kived
striped105214362striped
strive95020962strive_
striven103910752striven
striver104315202striver
strives104119372strives
survived1534072survived
swived133610632s_wived
thrived14458182thrived
achieved1743713achieved
acred87126353acr__ed
acrid86920103acri__d
acrider1038623acrider
active11313743active_
actives12311523actives
aeried74221863aeri_ed
archived17355993archived
ariled75620323_ariled
arrive91311793arrive_
arriver10117793arriver
arrives101311513arrives
ascribe1147743ascribe_
ascribes1246193ascribes
becrimed1565513becrimed
berimed124912283berimed
braved124817443_braved
bribed115312843_bribed
brined95118413_brined
buried94822373buri_ed
calved125215453_calved
caried94528693cari_ed
carved124320853_carved
caved116227563_c_aved
ceiled94114953_ceiled
chided135113963_chided
chimed145814833_chimed
chined125620063_chined
chive135117623_chive_
chives144317593_chives
chivied16368383_chivied
cited84421953_c_ited
civet105828733_c_ivet
coifed124113063_coifed
coiled95123933_coiled
coined94523603_coined
coved115027373_c_oved
craned96121653_craned
craped116120523_craped
crated94827773_crated
crave105626313_crave_
craven114113933_craven
craver114618463_craver
craves115825393_craves
crazed184714453_crazed
cred76530883_cr__ed
creed85727393_cr_eed
creped114115703_creped
crewed125316553_crewed
cribbed14407663_cribbed
cricked164814283_cricked
crier74724463_cri_er
cries75438403_cri_es
crikey15317783_crikey
crime94822693_crime_
crimes105521583_crimes
crimped143910763_crimped
cringed113312403_cringed
cripe95521143_cripe_
cripes105120873_cripes
crises84529433_crises
crisped124010103_crisped
crowed124717293_crowed
cruised103710213_cruised
curved124815223_curved
deceived1535893deceived
decried112612853decri_ed
deprived1546463deprived
derided102914253derided
derive103817043derive_
deriver114213913deriver
derives114017813derives
described1544953described
descried1248073descri_ed
dived106321373__dived
dried75321383_dri_ed
drive95318003_drive_
drivel105110383_drivel
driven105210143_driven
driver104714493_driver
drives105117113_drives
droved114611643_droved
escrowed1434653escrowed
fried95322913_fri_ed
frized193510683_frized
glaived12375973glaived
graved114818813_graved
grided95117043_grided
grieved1235283_grieved
grimed104714093_grimed
griped104114713_griped
grivet103517823_grivet
groved114413703_groved
hived125217913__hived
inscribed1444213inscribed
irised73913153_irised
jived165115043__jived
juried144212443juri_ed
lived95523723__lived
merited10313853merited
motived13357763motived
nerved104111683ner_ved
periled10316303periled
priced115018883_priced
prided103618033_prided
pried84426863_pri_ed
primed115118913_primed
prised94322203_prised
privet113821343_privet
prized184415393_prized
proved125016033_proved
raved94931433__raved
received1437983received
reived104518133_reived
relived115114683relived
revived144211653revived
riced85825543__riced
riled65833253__riled
rimed84826373__rimed
riped85226433__riped
rive75537723__rive_
riven85121623__riven
river85731693__river
rives85336003__rives
rivet85636363__rivet
roved95323553__roved
sacred94917103sacr__ed
sailed74327763s_ailed
sained75424243s_ained
salved103916423s_alved
sardined10268663sardined
saved95127113s__aved
savvied1433803savvied
scabbed14408223scabbed
scalded11409763scalded
scaled94822443sc_aled
scalped124411993scalped
scammed14479543scammed
scamped144711963scamped
scanned104110893scanned
scanted104114393scanted
scaped115519553sc_aped
scared95227293sc_ared
scarfed134711183scarfed
scarier94017873scari_er
scarified1547293scarified
scarped124314393scarped
scarphed1635433scarphed
scarred104512633scarred
scarted104816123scarted
scarves124511623scarves
scathed134012643scathed
scatted103512773scatted
scended11329873scended
scented102811883scented
schemed1577753schemed
scoffed16266183scoffed
scolded11358853scolded
sconced12359173sconced
scooped124611743scooped
scooted103612273scooted
scoped115116653sc_oped
scorched16187193scorched
scored94621133sc_ored
scoriae9310893scoriae_
scorified1546183scorified
scorned10229953scorned
scoured103811153scoured
scouted104112033scouted
scowed124413823sc_owed
scowled13398183scowled
scragged1335813scragged
scraiched1744203scraiched
scraighed1643593scraighed
scrammed1555003scrammed
scrape105917573scrape_
scraper114513403scraper
scrapes116217663scrapes
scrapped1556533scrapped
scrawled1445903scrawled
screaked15246973screaked
screamed13277593screamed
scree720031703scr__ee
screeded1235633screeded
screeds106210283scr_eeds
screen85216013scr_een
screened1137403screened
screes85023963scr_ees
screw109318533scr__ew
screwer124410063screwer
scribal1137963scribal
scribbled16174033scribbled
scribers12307953scribers
scrim95419723scri__m
scrimp125110583scri_mp
scrimper1455753scrimper
scrimps13517903scrimps
scrimpy16486133scrimpy
scrims104615933scri_ms
scrip96619193scri__p
scrips105316033scri_ps
script105717903scri_pt
scripter12137773scripter
scripts11509373scripts
scrivener1443113scrivener
scriving14258763scriving
scrod85115063scr__od
scrolled1137043scrolled
scrooped1356403scrooped
scrouged1235373scrouged
scrubbed1533853scrubbed
scrummed1554313scrummed
scrupled1335813scrupled
scubaed1236123scubaed
scudded12215933scudded
scuffed16298243scuffed
sculked14307183sculked
sculled102911693sculled
sculped12398253sculped
scummed14347913scummed
scurried11267053scurried
scurvier13255883scurvier
scurvies13248123scurvies
scythed16385303scythed
secreted1138633secreted
seined74023063s_eined
seised74218123s_eised
seized164313653s_eized
sered65737293ser__ed
serged84118763ser_ged
seriated92717023seriated
series64540973seri_es
seriffed1594973seriffed
serine65432673serine_
serines74229543serines
serried82513963serried
serve85425963ser_ve_
server94917713ser_ver
serves94423653ser_ves
serviced1435613serviced
shaved135118383s_haved
sheaved143411633sheaved
shelved14379933shelved
shied96125493s_hi_ed
shined104620783s_hined
shirked153710463shirked
shirred113710493shirred
shive114423423s_hive_
shiver124517373s_hiver
shives124921413s_hives
shoved134214273s_hoved
shred98125613shr__ed
shrewed14589843shrewed
shriek134211103shri_ek
shrieked16265173shrieked
shrieve13417683shrieve
shrieves14297093shrieves
shrike134513243shrike_
shrikes144412393shrikes
shrilled1246863shrilled
shrimped1634213shrimped
shrine94920053shrine_
shrines104618693shrines
shriveled1643153shriveled
shrivels14376443shrivels
shrivers14419103shrivers
shrove125412223shrove_
sided74825953s__ided
sieved104611443s_ieved
siped84927683s__iped
sired66134283s__ired
siruped1036013siruped
sited65130743s__ited
siver85728613s__iver
sized155519243s__ized
skeined1236773skeined
skied104417753s_ki_ed
skirled12348183skirled
skirred12347073skirred
skirted12388613skirted
skited114313473s_kited
skive124614113s_kive_
skiver134612103s_kiver
skives134113943s_kives
skydived2051563skydived
slaved104017043s_laved
sleaved113611133sleaved
sleeved11419913sleeved
sliced94416313s_liced
slimed94915123s_limed
sliped95417063s_liped
sliver94116593s_liver
sluiced1046053sluiced
smiled93716433s_miled
smirked14307233smirked
snailed83811923snailed
sniped94913483s_niped
snivel9368853s_nivel
soiled73822473s_oiled
solved105312933s_olved
sopited104211053sopited
sorbed94916513sor_bed
sored66141783sor__ed
sorites73825243sorites
sorned74820043sor_ned
sorted74523713sor_ted
sortied83314093sortied
speiled104412123speiled
speired103811103speired
spiced115218313s_piced
spied85427713s_pi_ed
spiked134915553s_piked
spiled94621993s_piled
spined95423943s_pined
spired94921863s_pired
spirited1148963spirited
spirted103913073spirted
spited94820443s_pited
spliced124310593spliced
splined105013113splined
spoiled104811353spoiled
sprained1138433sprained
sprayed13398903sprayed
sprier84119063spri_er
sprigged13316213sprigged
springed123911313springed
sprinted113411163sprinted
sprite84421773sprite_
sprites94220333sprites
spritzed2044783spritzed
spruced12307523spruced
squired173710053squired
stained84215343stained
starved114911573starved
staved103918053s_taved
steeved113610133steeved
stied65723033s_ti_ed
stiped94517073s_tiped
stirred8359693stirred
stiver93915733s_tiver
storied8515163stori_ed
strafed114413323strafed
strained9412253strained
straked125415343straked
strawed114813613strawed
strayed114513283strayed
strewed115811333strewed
striae65422273striae_
striated93414153striated
stride75420963stride_
strider84315723strider
strides84520393strides
strife95318363strife_
strifes104716583strifes
strike105619733strike_
striker113714173striker
strikes114719093strikes
stringed102911873stringed
stripe85822443stripe_
striper94514783striper
stripes95320573stripes
stripped1357093stripped
strivers113911843strivers
stroked124613623stroked
strove95014793strove_
strowed115312143strowed
stroyed114110863stroyed
stuiver10447083stuiver
suited74019423s_uited
surfed103814463sur_fed
surged84118883sur_ged
surmised1136853surmised
survey124111663sur_vey
survive1335933survive_
surviver1434683surviver
survives1436333survives
swerved1455703swerved
swiped123811093s_wiped
swirled11308223swirled
swive115316193s_wive_
swivel12369323s_wivel
swives123915183s_wives
swivet123615473s_wivet
syringed13377583syringed
syruped1334543syruped
thrive125313223thrive_
thriven13447023thriven
thriver13479123thriver
thrives134611713thrives
triced95518673_triced
tried65026913_tri_ed
trined74920713_trined
trivet93721883_trivet
unlived112511373unlived
unrimed102211633unrimed
updived1434093updived
upriver12196933upriver
varied104817863vari_ed
varved134110603var_ved
waived134511283_waived
wived125121503__wived
wried95518563_wri_ed

Search took 7 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 Limit1340274456.39020974.5
3Display Results4454450.1562852.6
 (SQL Overall)1786914456.70226662.3
 
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.