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

162 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
scrieves1338761(None) 
scrieve12448331scrieve_
scrieved14366201scrieved
scrives124414271scri_ves
shrieves14297091shrieves
achieves1645522achieves
grieves1137322_grieves
screes85023962scr_e_es
scribes113713202scri_bes
scries85226822scri__es
scrive115414942scri_ve_
scrived134511112scri_ved
shrieve13417682shrieve_
shrieved15276072shrieved
shrives134416172shri_ves
sieves93216002s__ieves
slieves10378962s_lieves
strives104119372stri_ves
achieve1545023achieve_
achieved1743713achieved
achiever1643843achiever
achievers1743433achievers
actives12311523acti_ves
aggrieves14101903aggrieves
arrives101311513arri_ves
ascribes1246193ascri_bes
believes13449403believes
breves115516423_br_eves
chives144317593_chi_ves
craves115825393_cr_aves
creeses93914623_creeses
cremes104517993_cr_emes
crepes105419343_cr_epes
criers83918583_crie_rs
cries75438403_cri__es
crimes105521583_cri_mes
cringes103215503_cringes
cripes105120873_cri_pes
crises84529433_cri_ses
derives114017813deri_ves
drives105117113_dri_ves
friezes19418913_friezes
grieve1047243_grieve_
grieved1235283_grieved
griever1136033_griever
grievers1255473_grievers
nieves94311293__nieves
parietes10714543parietes
reeves94721493__reeves
reives95723043__reives
relieves114210393relieves
reprieves1475113reprieves
retrieves1265653retrieves
riever94811653__riever
rievers104311453__rievers
rives85336003__ri_ves
sacrileges1352723sacrileges
sarees65329943sar_e_es
scarifies1439603scarifies
scarves124511623sc_arves
scenes84520353sc__enes
schemes1489663sc_hemes
sciences1238773sc_iences
scoleces1237073scoleces
scorifies1448023scorifies
scrapes116217663scr_apes
scrapies124612473scrapies
screaks13469353scr_eaks
screams114810613scr_eams
scree720031703scr_e_e_
screeches1695643screeches
screed95718923scr_e_ed
screeded1235633screeded
screeds106210283scr_eeds
screen85216013scr_e_en
screened1137403screened
screener1037563screener
screeners1136723screeners
screens95212173scr_eens
screwed135710653scr_ewed
screwer124410063scr_ewer
screwers13358053scr_ewers
screws115513883scr_e_ws
scribbles15184953scribbles
scribe104613533scri_be_
scribed124510643scri_bed
scriber113910963scri_ber
scribers12307953scribers
scried95817303scri__ed
scrieving1534133scrieving
scrimped1555313scrimped
scrimper1455753scrimper
scrimpers1554633scrimpers
scrimps13517903scri_mps
scrims104615933scri__ms
scrips105316033scri__ps
scripted13117553scripted
scripter12137773scripter
scripters13116673scripters
scripts11509373scri_pts
scrivener1443113scrivener
scriveners1543143scriveners
scrooges1137163scrooges
scrouges1136683scrouges
scruples1237433scruples
secretes10410473secr_etes
serenes73222903ser_enes
seriates82620673seriates
seriemas1047193seriemas
series64540973seri__es
serines74229543seri_nes
serves94423653ser__ves
sheeves133911953s_heeves
shives124921413s_hi_ves
shrieked16265173shrieked
shrieker15265653shrieker
shriekers16224423shriekers
shrieks14377673shrie_ks
shrieval1443363shrieval
shrikes144412393shri_kes
shrines104618693shri_nes
shrive125216953shri_ve_
shrived144712183shri_ved
shrivel13479403shri_vel
shrivels14376443shrivels
shriven13379653shri_ven
shriver134712193shri_ver
shrivers14419103shrivers
sieges73816833s__ieges
sieve84918843s__ieve_
sieved104611443s__ieved
sirees64624583sir_e_es
sirrees73410563sirre_es
skives134113943s_ki_ves
sleeves103311343s_leeves
slieve9359273s_lieve_
soirees72411643soire_es
sorites73825243sori_tes
spiremes12397623spiremes
sprees85620643spr_e_es
springes114014033springes
sprites94220333spri_tes
spritzes1946933spritzes
steeves103410903s_teeves
striates83417083striates
strides84520393stri_des
strifes104716583stri_fes
strikes114719093stri_kes
stripes95320573stri_pes
strive95020963stri_ve_
strived114713663stri_ved
striven103910753stri_ven
striver104315203stri_ver
strivers113911843strivers
survives1436333survives
swives123915183s_wi_ves
syringes122810213syringes
syrinxes18294423syrinxes
thieves1346903_thieves
thrives134611713thri_ves
trienes74118413_trienes
unreeves11106163unreeves

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621626.62322068.9
3Display Results1621620.0632571.4
 (SQL Overall)1786911626.84226116.8
 
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.