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

64 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
dupe76630601dup_e
duped95118321duped
duper85519001duper
dupes86425931dupes
duple85315861duple
rupee7321281rupee
cupel9514302cupel
cuvee10316142cuvee
dee47665822d__ee
donee66931012donee
dope76038892dop_e
doped95326712doped
doper86128392doper
dopes84935042dopes
dopey116020352dopey
dree56638322d_ree
drupe85012992drup_e
drupes94912652drupes
duce76933502du_ce
duces86327472duces
dude65629662du_de
duded84417132duded
dudeen857172dudeen
dudes75424372dudes
due45249862du__e
duel56729702du_el
dues56045502du_es
duet56446262du_et
duke95628102du_ke
duked115218462duked
dukes105023472dukes
dulse65415042dulse
dumped123814492dumped
dumper114615212dumper
dunce86319262dunce
dune56137582du_ne
dunes65332172dunes
dup67637882dup__
dupers94615602dupers
dupery12378742dupery
duplex16386972duplex
dupped124411642dupped
dups75929512dup_s
dure56341812du_re
dured75025402dured
dures65635922dures
duvet9321872duvet
epee64628502_epee
fusee86224582fusee
fuzee175718882fuzee
jupe134921002jup_e
jupes145218552jupes
ouphe104413262ouphe
pee56066512__pee
pupae96515642pupae
puree74632842puree
rupees8312572rupees
supe65932762sup_e
super74924482super
supes75628302supes
tepee74724212tepee
topee76029952topee
toupee8316132toupee
tutee5423522tutee

Search took 2 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 Filter178691538000.296603685.8
2DLD Change Limit53800641.61033416.1
3Display Results64640.0134923.1
 (SQL Overall)178691641.91993116.7
 
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.