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

82 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
drupes9491265(None) 
drapes95419651drapes
drupe85012991drupe_
druses75517251druses
dupes86425931d_upes
brumes106417072brumes
brutes86118682brutes
bruxes154811022bruxes
coupes105022522coupes
crapes104727692crapes
crepes105419342crepes
cripes105120872cripes
croupes114613102croupes
cruces105117542cruces
crudes96218622crudes
cruses88127712cruses
cruxes154911562cruxes
daubes94913702daubes
deuces94015512deuces
dopes84935042d_opes
douses74928932douses
drakes114715862drakes
drape85319632drape_
draped105314362draped
draper94315692draper
drapers105313352drapers
drapey125010582drapey
drees65628522dr_ees
dries64733672dr_ies
drips85417232drip_s
drives105117112drives
drones75023432drones
drops85719502drop_s
droves105116672droves
drubs85913832dru_bs
drudges10308872drudges
drugs75214652dru_gs
druids8368092druids
drums85415872dru_ms
drunks11427512drunks
druse64817662druse_
duces86327472d_uces
dudes75424372d_udes
dues56045502d_u_es
dukes105023472d_ukes
dunes65332172d_unes
dupe76630602d_upe_
duped95118322d_uped
duper85519002d_uper
dupers94615602d_upers
dups75929512d_up_s
dures65635922d_ures
erupts8348902erupts
grapes95123122grapes
gripes94619872gripes
gropes95220402gropes
grues65721962gru_es
grumes94415552grumes
jupes145218552_jupes
loupes84918052loupes
prudes94215442prudes
prunes83419062prunes
rapes75740722_rapes
ripes75435772_ripes
ropes75940062_ropes
rubes74928412_rubes
rues46044482_ru_es
rules55234252_rules
runes55530222_runes
rupee7321282_rupee
rupees8312572_rupees
ruses56136582_ruses
stupes84116952stupes
supes75628302_supes
taupes8212672taupes
trapes85024462trapes
tripes85324872tripes
tropes84824352tropes
troupes94112852troupes
truces84916332truces
trues54925322tru_es
uruses63616502uruses

Search took 4 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.343520965.0
2DLD Change Limit82551822.62631436.0
3Display Results82820.0136307.7
 (SQL Overall)178691822.98259923.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.