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

96 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
scurril94511(None) 
scurrile1055071scurrile
currie84317262_currie
scurried11267052scurried
scurries102911482scurries
scurry11419592scurr_y
scurvily1643782scurvily
blurrily1343913blurrily
carrel84718633_carrel
cirri7710723_cirri_
corral83616253_corral
corrie83621223_corrie
crural8610633_crural
cupric1249123_cupric
curari84414403_curari_
curaris94114773_curaris
curia74523773_cu_ria
curial84019153_curial
curie74533043_cu_rie
curio74221213_cu_rio
curl66035053_cu_r_l
curlily1238383_curlily
curr65429653_curr__
curran8312023_curran
curred94319263_curred
curricle12145933_curricle
curried103313653_curried
currier93316703_currier
curries93723163_curries
curring103616843_curring
currish1238353_currish
currs75624393_curr_s
curry105920343_curr_y
curtail9299663_curtail
curtal83914543_curtal
dhurrie1153953dhurrie
durrie73713263_durrie
furrily1337613_furrily
saurel6511993sau_rel
scarily12311703sc_arily
scarred104512633scarred
scarrier10298453scarrier
scarring112511513scarring
scarry116311183scarr_y
schorl1179803schor_l
schrik15206703sc_hrik
scirrhi1242293scirrhi
sciurid1044923sciurid
sciuroid1144403sciuroid
scleral937863scleral
scoria8513503sc_oria
scrawl11208083sc_rawl
scrim95419733sc__rim
scrip96619193sc__rip
scroll8310163sc_roll
scudi85112163scu_di_
scull75315763scu__ll
sculpin11236653sculpin
scummily1743303scummily
scurf104719323scu_r_f
scurfier13267053scurfier
scurfs113210813scu_rfs
scurfy14338763scu_rfy
scurrility1552143scurrility
scurrilous1262023scurrilous
scurrying15183833scurrying
scurvier13255883scurvier
scurvies13248123scurvies
scurvy14386103scu_rvy
serail64222673s_erail
sherris10168803sherris
slurred8359193slurred
slurried9285943slurried
slurries82710413slurries
slurring9288833slurring
slurry9378603slurr_y
sorrel6413553s_orrel
sorrily1039833s_orrily
souari6311383souari_
souaris7312333souaris
spurred103610623spurred
spurrer93710223spurrer
spurrey12307813spurrey
spurrier10297693spurrier
spurries102311323spurries
spurring11339763spurring
spurry11429123spurr_y
squirrel17414533squirrel
sturdily1245083sturdily
sural55931263s_u_ral
surlily10310003s_urlily
surra55521343s_urr_a
surras65919533s_urras
surreal739233s_urreal
surrey94414583s_urrey
surveil1045093s_urveil

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 Filter1786911340270.1561145455.1
2DLD Change Limit134027967.11018850.5
3Display Results96960.0462087.0
 (SQL Overall)178691967.31224438.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.