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

167 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
scrieve1244833(None) 
scrieved14366201scrieved
scrieves13387611scrieves
scrive115414941scri_ve
shrieve13417681shrieve
achieve1545022achieve
grieve1047242_grieve
scree720031712scr_e_e
scribe104613532scri_be
scried95817302scrie_d
scries85226822scrie_s
scrived134511112scrived
scrives124414272scrives
shrieved15276072shrieved
shrieves14297092shrieves
shrive125216952shri_ve
sieve84918842s__ieve
slieve9359272s_lieve
strive95020962stri_ve
achieved1743713achieved
achiever1643843achiever
achieves1645523achieves
active11313743acti_ve
aggrieve13102043aggrieve
arrive91311793arri_ve
ascribe1147743ascri_be
believe12519773believe
breve105317053_br_eve
chive135117623_chi_ve
crave105626313_cr_ave
creese84014333_creese
creme94319323_cr_eme
crepe95520723_cr_epe
cried84624283_crie_d
crier74724463_crie_r
criers83918583_criers
cries75438403_crie_s
crime94822693_cri_me
cringe93515483_cringe
cripe95521143_cri_pe
derive103817043deri_ve
drive95318003_dri_ve
frieze18378143_frieze
grieved1235283_grieved
griever1136033_griever
grieves1137323_grieves
lieve86315473__lieve
nieve85613183__nieve
ocreae83310273ocr_eae
pareve114613013par_eve
reeve84121323__reeve
reive85522943__reive
relieve105010693relieve
reprieve1375443reprieve
retrieve1175693retrieve
riever94811653__riever
rive75537723__ri_ve
sacrilege1242773sacrilege
saree55044663sar_e_e
scalene9310773scalene
scarier94017873scarie_r
scariest101615943scariest
scariose1037593scariose
scene77220573sc__ene
scheme1379633sc_heme
schliere1343843schliere
science1138783sc_ience
scoriae9310903scori_ae
scrape105917573scr_ape
scrapie115010943scrapie
screak125311063scr_eak
scream104814253scr_eam
screech1435223screech
screed95718933scr_eed
screeded1235643screeded
screeds106210293screeds
screen85216023scr_een
screened1137413screened
screener1037573screener
screens95212183screens
screes85023973scr_ees
screw109318543scr_e_w
screwed135710663scr_ewed
screwer124410073scr_ewer
screws115513893scr_ews
screwy14659463scr_ewy
scribal1137963scribal
scribble14175433scribble
scribed124510643scribed
scriber113910973scriber
scribers12307963scribers
scribes113713203scribes
scrieving1534133scrieving
scrim95419743scri__m
scrimp125110583scri_mp
scrimped1555313scrimped
scrimper1455763scrimper
scrimps13517903scrimps
scrimpy16486133scrimpy
scrims104615933scri_ms
scrip96619193scri__p
scrips105316033scri_ps
script105717903scri_pt
scripted13117553scripted
scripter12137783scripter
scripts11509373scripts
scrivener1443113scrivener
scrooge1037183scrooge
scrouge1036353scrouge
scruple1137193scruple
secrete9311073secr_ete
serene63522353ser_ene
seriate73722473seriate
seriema938403seriema
series64540973serie_s
serine65432673seri_ne
serve85425963ser__ve
sheeve123412843s_heeve
shive114423423s_hi_ve
shriek134211103shrie_k
shrieked16265173shrieked
shrieker15265653shrieker
shrieks14377673shrieks
shrieky17364803shrieky
shrieval1443363shrieval
shrike134513243shri_ke
shrine94920053shri_ne
shrived144712183shrived
shrivel13479403shrivel
shriven13379653shriven
shriver134712193shriver
shrives134416173shrives
shrove125412233shr_ove
siege66718443s__iege
sieved104611443s__ieved
sieves93216003s__ieves
siree55238813sir_e_e
sirree64017343sirre_e
skive124614113s_ki_ve
sleeve93411593s_leeve
slieves10378963s_lieves
soiree62919483soire_e
spireme11478363spireme
spree74830863spr_e_e
sprier84119063sprie_r
spriest92718643spriest
springe103913983springe
sprite84421773spri_te
steeve93710903s_teeve
striae65422273stri_ae
striate74218953striate
stride75420963stri_de
strife95318363stri_fe
strike105619733stri_ke
stripe85822443stri_pe
strived114713663strived
striven103910753striven
striver104315203striver
strives104119373strives
strove95014793str_ove
survive1335933survive
swive115316193s_wi_ve
syringe11349473syringe
thieve1235963_thieve
thrive125313223thri_ve
triene64316383_triene
unreeve10176763unreeve

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271678.31016128.4
3Display Results1671670.0503340.0
 (SQL Overall)1786911678.75020421.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.