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

103 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
scrieving153413(None) 
scriving14258761scri_ving
shrieving1633971shrieving
achieving1843302achieving
grieving1385892_grieving
screeding1336322screeding
screening1247192screening
screwing14288232scr_ewing
scribing13238182scri_bing
scrimping1634952scrimping
scripting1437472scripting
shrieking1734582shrieking
shriving15268452shri_ving
sieving112311232s__ieving
striving122611392stri_ving
aggrieving1681483aggrieving
arriving1237363arri_ving
ascribing1444953ascri_bing
believing1535283believing
briefing1436943_briefing
craving134015733_cr_aving
creeling113513363_creeling
creeping133310103_creeping
creping122913653_cr_eping
crewing133212633_cr_ewing
cribbing15276843_cribbing
cricking173412653_cricking
crimping15299783_crimping
cringing123311383_cringing
crisping13319663_crisping
deriving132510743deri_ving
driving123910713_dri_ving
reeving113717663__reeving
reiving113316843__reiving
relieving1336693relieving
reprieving1644893reprieving
retrieving1445293retrieving
riving104521423__ri_ving
scarifying1945013scarifying
scarpering1545413scarpering
scheming1636633sc_heming
schilling15286393schilling
scorifying1944473scorifying
scragging1435273scragging
scraiching1843793scraiching
scraighing1742933scraighing
scramming1634883scramming
scraping133310863scr_aping
scrapping1635743scrapping
scrawling15195583scrawling
screaking16228243screaking
screaming14217833screaming
screeching1843643screeching
screenings1343263screenings
scribbling1742553scribbling
scrieve12448333scriev__e
scrieved14366203scriev_ed
scrieves13387613scriev_es
scrolling12187803scrolling
scrooping1446593scrooping
scrouging1335263scrouging
scrubbing1633933scrubbing
scrumming1654023scrumming
scrupling1435193scrupling
scrying1338663scr__ying
secreting1279823secr_eting
seriating10916403seriating
serving113014983ser__ving
shieling123512403s_hieling
shrewing15228093shr_ewing
shrilling13307693shrilling
shrimping1734063shrimping
shrining122610853shri_ning
shrinking1735653shrinking
shriveling1743253shriveling
sieging92613203s__ieging
skiving15298373s_ki_ving
sleeving12359283s_leeving
sortieing1046163sortie_ing
spieling113212523s_pieling
spiering112713353s_piering
sprigging1435893sprigging
springing1338743springing
sprinting12310033sprinting
spritzing2135393spritzing
steeving12359653s_teeving
streeking14217453streeking
streeling10189483streeling
strewing12289853str_ewing
striating10914193striating
striding102713603stri_ding
striking133012233stri_king
stringing1139753stringing
striping112612523stri_ping
stripling1257783stripling
stripping1436493stripping
surveying1644963surveying
surviving1644163surviving
swiving14358953s_wi_ving
syringing1435883syringing
thieving1535143_thieving
thriving15246353thri_ving
unreeving1336213unreeving

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 Filter1786911486410.483369960.7
2DLD Change Limit1486411037.78319098.2
3Display Results1031030.0462239.1
 (SQL Overall)1786911038.31221498.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.