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

314 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
presided1241055(None) 
preside10715611preside_
presider11410421presider
presides11414911presides
resided95217701_resided
preceded1438292preceded
precised133213412precised
precited133013812precited
precoded1438862precoded
prefaded1537822prefaded
prefiled143310572prefiled
prefired144310752prefired
prefixed21357702prefixed
preguided1443922preguided
preluded1236472preluded
premised133013192premised
premixed20338012premixed
presaged1238802presaged
prescinded1644342prescinded
president12410992president
presiders1248212presiders
presidia1147272presidia
presidio1146152presidio
presifted1536872presifted
presliced1435982presliced
pressed103317312pres_sed
presumed1337972presumed
prevised143611072prevised
prewired14358472prewired
prided103618032pr__ided
provided1536842provided
reside74224932_reside_
resider84615802_resider
resides84523282_resides
resiled84621982_resiled
resined84522652_resined
resited85122422_resited
resized174614902_resized
beside95114613_beside_
besides104814533_besides
betided114810203_betided
braided114013213br_aided
breaded115014063bre_aded
credited1238253credited
crested103416533cres_ted
creviced1634453creviced
crusaded1244233crusaded
decided124312423_decided
derided102914253_derided
desired9311983_desired
dreaded103612023dre_aded
dreidel934473dre_idel
dressed93511873dres_sed
elided84814673__elided
fireside1247003fireside_
firesides1346603firesides
foreside12310303foreside_
foresides1339703foresides
frescoed1436053frescoed
freshed143312593fres_hed
grecized2134433grecized
grided95117043gr__ided
lopsided1244253lopsided
oreide7311673ore_ide_
oreides8312023ore_ides
palsied102911303palsi_ed
peined94918843p_e_ined
peised94817683p_e_ised
pended103819013p_e_nded
periled10316323p_eriled
perished14310083perished
peroxided2045073peroxided
persisted1247143persisted
perspired1444213perspired
persuaded1344373persuaded
pervaded1535373pervaded
pesade9311103p_esade_
pesades10310903p_esades
pestled102711443p_estled
phrensied1543373phrensi_ed
plaided11409643p_laided
pleaded113511263ple_aded
poesies93217403poesi_es
poetised1138523poetised
poetized2037983poetized
portside1138163portside_
posited10511493p_osited
praesidia1243333praesidia
praised104214813pr_aised
preached163412063preached
preacted132710943preacted
preaged11612333pre_aged
prearmed1397993prearmed
prebade12310283prebade_
prebaked1737173prebaked
prebid113512843prebi__d
prebidden1542613prebidden
prebids12399883prebid_s
prebilled1445063prebilled
prebind123810643prebi_nd
preboiled1455783preboiled
precede1239653precede_
precedes13310713precedes
precipe133012123precipe_
precipes143212213precipes
precise113518173precise_
preciser123411663preciser
precises123218333precises
precluded1544223precluded
precode12311853precode_
precodes13711573precodes
precured1339993precured
predated12513273predated
predicted1538913predicted
predive13511083predive_
predried12309573predried
preed85128123pre___ed
preedited1337633preedited
preened103214993pre_ened
prefaced1638423prefaced
prefade1339013prefade_
prefades1439533prefades
prefile123413183prefile_
prefiles133113443prefiles
prefilled1535513prefilled
prefire124012813prefire_
prefires134313283prefires
prefixes20389233prefixes
prefunded1644693prefunded
preguide1255423preguide_
preguides1344863preguides
prejudged2142753prejudged
prelife1279943prelife_
prelives13310383prelives
preloaded1335923preloaded
prelude1038013prelude_
preluder1135733preluder
preludes1137833preludes
premade12311443premade_
premed114617763pre__med
premie103617993premi_e_
premier113515633premi_er
premiered14237093premiered
premies113823063premi_es
premise113818553premise_
premises123018273premises
premixes193110083premixes
premolded1544683premolded
prenticed14118063prenticed
preorder1136463preorder
preowned1435213preowned
prepared132210873prepared
prepaved16177233prepaved
prepped11329903pre_pped
prepriced1676643prepriced
prerinsed1246323prerinsed
presage10312293presage_
presager1138443presager
presages11312203presages
presale9416353presale_
presales10315263presales
prescind1338393prescind
prescored14409403prescored
prescribed17105373prescribed
prese75228383pres__e_
presented12311633presented
preserved15107563preserved
preset84430983pres__et
preshaped1745523preshaped
preshipped1742963preshipped
preshowed1875183preshowed
presidency1844653presidency
presidents1347023presidents
presidial1247213presidial
presiding13510903presiding
presidios1245773presidios
presidium1445303presidium
presift12312223presi_ft
presifts1366593presifts
presleep1244493presleep
preslice1258623preslice_
preslices1338213preslices
presoaked1635653presoaked
presold1059603pres_old
presolved1545273presolved
presorted1239453presorted
presser93717623pres_ser
presses93523153pres_ses
pressmen1238833pressmen
pressured1237333pressured
prester93519623pres_ter
prestige11310733prestige_
prestiges12310593prestiges
prestored125111673prestored
presume11310303presume_
presumer1247583presumer
presumes1239843presumes
pretaped13339133pretaped
pretended1337193pretended
prettied1159253prettied
pretyped16306123pretyped
preunited1246803preunited
prevailed1536043prevailed
preview1536473previ_ew
previewed1843423previewed
previse123713793previse_
previses133814283previses
previsited1645183previsited
prevued1337143pre_vued
prewire124311143prewire_
prewires133811013prewires
prexies163415003prexi_es
preyed125313203pre__yed
priced115018883pr__iced
pride84724733pr__ide_
prides94324183pr__ides
pried84426863pr__i_ed
priested1138393pries_ted
primed115118913pr__imed
prised94322203pr__ised
prisoned1138813prisoned
prissed103311263pris_sed
prized184415393pr__ized
prodded1257733pr_odded
profiled14338523profiled
profited14279973profited
promised133010873promised
propined133111503propined
prosed94921093pros__ed
prosier93817483prosi_er
provide1339853provide_
provider1436703provider
provides1439883provides
pyramided1873833pyramided
raided85017703_r_aided
readded103310733_readded
readied93316623_readied
receded112713043_receded
recited104319103_recited
recoded113115033_recoded
redded94019553_re_dded
reded74829123_re__ded
reeded84022563_re_eded
refiled114318653_refiled
refined114720003_refined
refired115116993_refired
refixed183611153_refixed
regilded1135543_regilded
rehired115013153_rehired
reined74425523_re_ined
reived104518133_re_ived
relied74926233_reli_ed
relined85321933_relined
relived115114683_relived
reminded123411523_reminded
remised103516843_remised
remixed173510743_remixed
rended84524103_re_nded
reoiled84316853_reoiled
repined104918773_repined
resailed93613063_resailed
resawed113111183_resawed
rescinded1335763_rescinded
rescued10410043_rescued
reseed74823293_res_eed
reseeded1038093_reseeded
reseized1839213_reseized
resewed113011823_resewed
reshined123011123_reshined
reshoed112212153_reshoed
resid64124093_resi__d
resident9313753_resident
residers93311883_residers
resids74219153_resid_s
residua8286623_residua
residue8689863_residue
residues9338813_residues
resifted12310153_resifted
resigned1038863_resigned
resile64627673_resile_
resiles74026543_resiles
resisted9312693_resisted
resite64128453_resite_
resites74027793_resites
resize154117723_resize_
resizes164216843_resizes
resodded1136353_resodded
resoled84119283_resoled
resowed113712253_resowed
respaded1238133_respaded
respired1148993_respired
respited11410813_respited
rested74430783_res_ted
resumed10310623_resumed
retied75924983_reti_ed
retiled84420513_retiled
retimed104714653_retimed
retired84620143_retired
reviled114417923_reviled
revised113815483_revised
revived144211653_revived
rewiden1137533_rewiden
rewinded13277673_rewinded
rewired115413283_rewired
rosined84911903_rosined
sided74825953___sided
subsided1257663subsided
treaded95014283tre_aded
trended94011763tre_nded
tressed83714263tres_sed
ureide7310363ure_ide_
ureides8311103ure_ides
wrested113410933wres_ted
wrestled12296763wrestled

Search took 9 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.423422437.4
2DLD Change Limit1461623147.57619292.8
3Display Results3143140.1262492.1
 (SQL Overall)1786913148.12521992.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.