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

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

71 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
strove9501479(None) 
shrove125412231shrove
stove85220251st_ove
strive95020961strive
strobe84513811strobe
strode75215971strode
stroke105116171stroke
trove85221921_trove
drove95518062_drove
estrone7413952estrone
grove95219332_grove
prove104823192_prove
restrove1138962restrove
rove75136982__rove
sarode75317512sarode
scrive115414942scrive
serve85425962ser_ve
shove114421042s_hove
shrive125216952shrive
starve94613742starve
stave85324992st_ave
steeve93710902steeve
stoae55024262st_oae
stoke94922512st_oke
stole54928812st_ole
stone55431182st_one
stooge73811662stooge
stope74727242st_ope
store56333812st_ore
stover94115642st_over
stoves93818922st_oves
strafe95215982strafe
strake104017392strake
striae65422272striae
stride75420962stride
strife95318362strife
strike105619732strike
stripe85822442stripe
strived114713662strived
striven103910752striven
striver104315202striver
strives104119372strives
strobes93813262strobes
stroked124613622stroked
stroker114113522stroker
strokes114316322strokes
stroll6311602stroll
stroma84313072stroma
strong74914882strong
strook10410302strook
strop77422242stro_p
strophe1239142strophe
strops86220382strops
stroud7310382stroud
strow88920572stro_w
strowed115312142strowed
strown96812092strown
strows96718272strows
stroy87720392stro_y
stroyed114110862stroyed
stroyer103510782stroyer
stroys95914602stroys
throve128012392throve
trave85223032_trave
trode65322852_trode
troke94821052_troke
trone55131862_trone
trope75725802_trope
trover95014662_trover
troves94719112_troves
unrove92511682unrove

Search took 3 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 Filter178691825510.360496363.9
2DLD Change Limit82551712.43633887.9
3Display Results71710.0164437.5
 (SQL Overall)178691712.81263545.9
 
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.