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 “scurrile” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

78 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
scurrile105507(None) 
scurril945111scurril_
curricle12145932_curricle
currie84317262_curri_e
scurried11267052scurried
scurries102911482scurries
scurvily1643782scurvily
blurrily1343913blurrily
bourride1144403bourride
carriole1089863_carriole
corrie83621233_corri_e
cuprite1159683_cuprite
curable112414513_curable
curarine10610713_curarine
curarize1988853_curarize
curdle95514313_cu_rdle
curiae84518373_cu_riae
curie74533043_cu_ri_e
curite85222943_cu_rite
curlily1238383_curlily
curricles13105423_curricles
curried103313653_curried
currier93316703_currier
curries93723163_curries
curring103616843_curring
currish1238353_currish
cursive1237833_cursive
curule83614123_cu_rule
dhurrie1153953dhurri_e
durrie73713263_durri_e
furrily1337613_furrily
murrine9411483_murrine
puerile9310093_puerile
scarily12311703sc_arily
scarrier10298453scarrier
scarring112511513scarring
scissile1044623scissile
sciurine1045233sciurine
sclerite10410713sclerite
scoriae9310903sc_oriae
scribe104613533sc__ribe
scrive115414943sc__rive
scruple1137193sc_ruple
scuffle15266893scu_ffle
scumble1337013scu_mble
scumlike1644353scumlike
scummily1743303scummily
scurfier13267053scurfier
scurrility1552143scurrility
scurrilous1262023scurrilous
scurry11419593scurr__y
scurrying15183833scurrying
scurvier13255883scurvier
scurvies13248123scurvies
scuttle936463scu_ttle
securable1347773securable
servile10310643s_ervile
slurried9285943slurried
slurries82710413slurries
slurring9288833slurring
sorrily1039833s_orrily
sourdine936893sourdine
spurrier10297693spurrier
spurries102311323spurries
spurring11339763spurring
spurtle937453spu_rtle
sterile7316603s_terile
sturdily1245083sturdily
subfile122010503s_ubfile
subrule939643s_ubrule
subtile91912623s_ubtile
sunrise7310813s_unrise
surlily10310003s_urlily
surmise9311083s_urmise
surprise1037673s_urprise
surprize1945843s_urprize
surtitle845283s_urtitle
survive1335933s_urvive

Search took 8 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.410435831.7
2DLD Change Limit146162787.31019994.8
3Display Results78780.0332363.6
 (SQL Overall)178691787.75323048.0
 
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.