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

166 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
deplores113953(None) 
deplore1039481deplore_
deplored1237231deplored
deplorer1136341deplorer
deplorers1245461deplorers
declares11611322declares
deplanes11311212deplanes
depletes112810642depletes
deployed1535912deployed
deployer1445632deployer
deployers1545062deployers
deploys1336522deplo_ys
deplumes1334942deplumes
depones103717092dep_ones
deports105012882dep_orts
deposes103117212dep_oses
diploes101111492diplo_es
diploses111110322diploses
explores1746252explores
implores12127042implores
peploses1269472peploses
splores91910952_splores
bedsores1157633bedsores
dapsones1138383dapsones
dealates92716683dealates
dealers84118613dealer_s
debones103315113de_bones
debtors1038533debtor_s
decares102818533de_cares
deciares11510633deciares
declare10411233declare_
declared1248753declared
declarer1148073declarer
declarers1236423declarers
declines113315803declines
decodes113914983de_codes
decolored1345673decolored
decolors1187713decolor_s
decors94017773de_cor_s
deflates123013943deflates
deflower15126083deflower
deflowers16145643deflowers
deforces14248403de_forces
deforest1238793de_forest
deforms1337803de_forms
deglazes1935463deglazes
dehorns11428363de_horns
dehorts11379773de_horts
dekares122710873de_kares
delates83526283de_lates
deles65139253de_l__es
deletes83117933de_letes
delimes10314193de_limes
dellies83622213de_llies
delouse839833de_louse
delouses9310013de_louses
deludes91810643de_ludes
deluges9169263de_luges
delvers113411993de_lvers
delves104917083de_l_ves
demoses103815833de_moses
demotes104717673de_motes
denotes83817003de_notes
dentures9312453dentures
departs104310683dep_arts
depeoples1444223depeoples
deperms1236603dep_erms
depilates12310923depilates
deplane10311413deplane_
deplaned1238663deplaned
deplete103010423deplete_
depleted12258723depleted
depleter11298863depleter
depleters12327543depleters
deploring1337853deploring
deploy1237583deplo__y
deplume1255063deplume_
deplumed1434083deplumed
depone93616553dep_one_
deponed113712873dep_oned
deport94922393dep_or_t
deported1249703dep_orted
deportee11510353dep_ortee
deportees1256643dep_ortees
deporter1169393dep_orter
deporters1277793dep_orters
depose94215763dep_ose_
deposed113412033dep_osed
deposer104011843dep_oser
deposers11359243dep_osers
depots94716343dep_o_ts
depraves1436873depraves
depress10239873dep__ress
deprives1438393deprives
depsides1238503depsides
deputes104911783dep_utes
deputies1157533deputies
desires81316133de_sires
desorbs10437713de_sorbs
detoxes1538803de_toxes
developes15155283developes
devolves15286263devolves
devotes113713753de_votes
deworms1338033de_worms
diploe9810153diplo_e_
diploids1247843diploids
diplomas1385993diplomas
diplonts1146473diplonts
diplosis11128413diplosis
dipoles101013753dip_oles
displodes1347863displodes
doblones1136763doblones
dolors75115313d_olor_s
duplexes1844053duplexes
elopes85918163_e_lopes
employes1555943employes
encores9315213_encores
ephors11311403_ephor_s
epodes94315563_ep_odes
eposes84418783_ep_oses
explodes1845803explodes
explore1646613explore_
explored1845083explored
explorer1744713explorer
explorers1843743explorers
felloes104114383fello_es
galores82614343_galores
gyplures14102153gyplures
haploses1338853haploses
helloes103717473hello_es
heptoses1338373heptoses
implodes13106393implodes
implore11176703implore_
implored13135373implored
implorer12125103implorer
implorers13124413implorers
lores55045403___lores
pelorus939273pe_lorus
peplos101211543peplo__s
pepluses1287023pepluses
peptones12311033peptones
pores75849033__p_ores
rebores95319163re_bores
reexplores1952853reexplores
replaces123114123replaces
replates102919273replates
repletes102812473repletes
repliers103710163repliers
replies94521043repl_ies
replots93412633replo_ts
replowed14127583replowed
replows12329703replo_ws
reports94916213rep_orts
reposes94021263rep_oses
reprobes121910293reprobes
reproves132011473reproves
rescores105415693rescores
restores85222993restores
senhores112810993senhores
senores73218113se_nores
splore81611303_splore_
spores84726613_sp_ores
telomes9310533te_lomes
temblores1344003temblores
velures1039093ve_lures
zeppoles2143583zeppoles

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.420425454.8
2DLD Change Limit1461621667.47019566.5
3Display Results1661660.0632634.9
 (SQL Overall)1786911667.95322468.4
 
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.