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

53 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
upsweep144257(None) 
upsweeps1541771upsweeps
outsweep1344912outsweep
sweep104715722__sweep
upkeep1434142up_keep
upstep1035502ups_tep
upswell1242722upswell
upswept1443472upswept
asleep847283_asleep
beweep13147253_beweep
miskeep1536403miskeep
outsleep1046013outsleep
outsweeps1443193outsweeps
outweep1236673outweep
peep85833693_p__eep
peesweep1541633peesweep
pewee10319973_pewee_
pewees11311393_pewees
seep66540343__s_eep
sheep105321523__sheep
sleep74920183__sleep
steep76020703__steep
sweeps114110513__sweeps
sweepy14447453__sweepy
sweer84918573__sweer
sweet85330523__sweet
unseen62012623uns_een
unsewed112911023unsewed
unsteel738793unsteel
unstep839223uns_tep
unswear1035003unswear
unswept1246013unswept
upheap13105213up_heap
upkeeps1532193up_keeps
upleap10106843up_leap
upsend9356883ups_end
upsent83314063ups_ent
upset73222593ups__et
upsets8409683ups_ets
upside9289803upside_
upsides10319633upsides
upsize17267303upsize_
upsized19246253upsized
upsizes18297163upsizes
upslope1144173upslope
upsteps1133743upsteps
upsweeping1861833upsweeping
upswelled1542893upswelled
upswells1342623upswells
upswing1335593upswing
upswung1341783upswung
upwell11285803up_well
weep95131653___weep

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 Filter1786911340270.1401276364.3
2DLD Change Limit134027536.78319759.3
3Display Results53530.0134076.9
 (SQL Overall)178691536.93625762.8
 
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.