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

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

41 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
shortlisted155198(None) 
shortlist1246682shortlist__
shortlists1344082shortlist_s
shoplifted1952093sho_plifted
shortlisting1651643shortlisting
shortsighted2061373shortsighted
amortised1285814amort_is_ed
boatlifted1651944_boatlifted
checklisted2351324checklisted
chorister1487144chor__ister
chortled14326614chortl___ed
forklifted2151354_forklifted
hardfisted1851864_hardfisted
hoisted113411294_ho___isted
moralised1239664_moralis_ed
mortised1178744_mort_is_ed
outlasted10128354__outlasted
relisted9312624___relisted
shitlist1148724sh_itlist__
shitlists1245534sh_itlist_s
shoplifter1852184sho_plifter
shoreline1246624shoreli_ne_
shorelines1346144shoreli_nes
shorted113614404shor____ted
shortened1345664short__ened
shortest11310784short_est__
shorthaired1851914shorthaired
shorthanded1952254shorthanded
shortie10411344short_i__e_
shorties11414584short_i__es
shortish1437424short_is__h
shortnesses1446794shortnesses
shortstop1452154short__stop
shortwaved2051804short_waved
shotted113912404sho_t___ted
sortied83314104s_ort_i__ed
spoliated1246914spo__liated
sporulated1345264sporul_ated
spotlighted1851664spo_tlighted
sterilised1145444sterilis_ed
waitlisted1452054_waitlisted

Search took 10 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 Filter1786911488190.420425454.8
2DLD Change Limit148819419.30016002.0
3Display Results41410.0133153.8
 (SQL Overall)178691419.73318359.3
 
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.