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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

132 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
deputies115753(None) 
deputes104911781deput_es
deputizes2144981deputizes
beauties10229522beauties
dauties83315762d_auties
decuries11312222decuries
deities82621922de_ities
depute94512302deput_e_
deputed114610172deput_ed
deputing12238792deputing
deputize2045422deputize
deputized2244332deputized
duties74921902d__uties
reputes94615962reput_es
agouties9337693agouties
amputees1245103amputees
beasties102514653beasties
cecities12312043cecities
cuties84927363__cuties
dainties9312403dainties
dautie72914703d_autie_
dawties113312703d_awties
dearies83526273de_aries
debates103718533debat_es
debuted11379333debut_ed
debuting12268633debuting
debuts93911753debut__s
decries103319803de_cries
decuples1395283decuples
decurves1435863decurves
deduces1168793dedu_ces
defies104624053de__fies
defuses114814593defu_ses
defuzes20398303defu_zes
deictics1345563deictics
deifies113317453de_ifies
delates83526283delat_es
deletes83117933delet_es
dellies83622213de_llies
deludes91810643delu_des
deluges9169263delu_ges
demies94825803de__mies
demotes104717673demot_es
demotics1338753demotics
denies74729643de__nies
denotes83817003denot_es
densities10310793densities
dentils84115583de_ntils
dentines93418403de_ntines
dentins83419223de_ntins
dentures9312453dentures
denudes91510043denu_des
departees1265723departees
deplanes11311213deplanes
depletes112810643depletes
deplores1139533deplores
deplumes1334943deplumes
depones103717093dep_ones
deportees1256643deportees
deposes103117213dep_oses
deposits1138843deposits
depots94716343depot__s
depraves1436873depraves
deprives1438393deprives
depsides1238503depsides
depths12428573dep_t_hs
depurates1239823depurates
deputy12426713deput__y
derates84028893derat_es
derbies103016053de_rbies
derries83124623de_rries
descries11311923descries
despites11410313despit_es
destines93619663de_stines
deuces94015513de_u_ces
deutzias1842633de_utzias
devotees12286283devotees
devotes113713753devot_es
dexies145018343de__xies
dhooties1237643dhooties
dhutis1035943d_huti_s
dilutes82911973dilut_es
dimities11314003dimities
dipodies1238413dipodies
dirties83119383d_irties
disputes1139653disput_es
ditties83116983d_itties
duperies11312813duperies
elutes64020313_elut_es
empties11712243_empties
epoxies1637753_epoxies
equites162212493_equites
equities17310773_equities
fealties1139993fealties
ferities111416713ferities
hearties11315413hearties
hepatics15198933hepatics
hepatizes2347823hepatizes
imputes1138083imput_es
jetties143613123je_tties
lealties8310793lealties
lefties10312073le_fties
lenities8315943lenities
leptins92412693lep_tins
levities11310713levities
neckties1445903neckties
penuries10311663penuries
peptics132610243pep_tics
peptides132610263pep_tides
peptids12239323pep_tids
peptizes21269853pep_tizes
pities83828083__pities
punties94520783__punties
putties94420023__putties
putzes174212523__putzes
realties8514853realties
reburies10311143reburies
refutes104515733refut_es
replies94521043rep_lies
reptiles103913063rep_tiles
repulses1038393repulses
repute84716093reput_e_
reputed104613483reput_ed
reputing112412603reputing
requites171511763requites
reties65436193re__ties
septics112810433sep_tics
septimes1238303sep_times
subdeputies1661953subdeputies
tenuities949763tenuities
tepefies1346893tepefies
verities111418043verities

Search took 8 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 Filter1786911461620.406440125.6
2DLD Change Limit1461621326.73621698.6
3Display Results1321320.0602200.0
 (SQL Overall)1786911327.20224811.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.