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

268 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
presider1141042(None) 
preside10715611preside_
presided12410551presided
presiders1248211presiders
presides11414911presides
resider84615801_resider
preciser123411662preciser
preluder1135732preluder
premier113515632premi_er
preorder1136462preorder
presager1138442presager
president12410992president
presidia1147272presidia
presidio1146152presidio
presser93717622pres_ser
prester93519622pres_ter
presumer1247582presumer
prosier93817492prosi_er
provider1436702provider
reside74224932_reside_
resided95217702_resided
residers93311882_residers
resides84523282_resides
arider74717743ar__ider
artsier768943artsi_er
beside95114613_beside_
besides104814533_besides
braider105112993br_aider
brasier94516753brasi_er
breeder103210043bre_eder
brevier1237773brevi_er
broider103912973br_oider
consider11310393consider
creasier103210203creasi_er
crepier1139753crepi_er
crosier94116583crosi_er
crusader1144273crusader
decider114213183_decider
derider93214973_derider
desirer8310783_desirer
dreidel934473dre_idel
dresser83611953dres_ser
dressier956863dressier
eider64624753__e_ider
fireside1247013fireside_
firesides1346613firesides
foreside12310303foreside_
foresides1339713foresides
frescoer1345983frescoer
fresher132612643fres_her
greasier9298083greasi_er
greedier1036083greedier
insider849733_insider
oreide7311673ore_ide_
oreides8312023ore_ides
outsider9269643outsider
periderm1346813p_eriderm
perkier133813123perki_er
persister1146833persister
persuader1244263persuader
pervader1444863pervader
pesade9311103p_esade_
pesades10310903p_esades
peskier13319113p_eskier
pester84827593p_es_ter
pestier94317403p_estier
pleader103511763ple_ader
poesies93217403poesi_es
poetiser1037313poetiser
poetizer1936813poetizer
portside1138163portside_
praesidia1243333praesidia
praiser93413943pr_aiser
preacher153211373preacher
prealter1048863prealter
preaver121011613pre_aver
prebade12310283prebade_
prebid113512843prebid__
prebidden1542613prebidden
prebids12399883prebid_s
precede1239653precede_
preceded1438293preceded
precedes13310713precedes
precipe133012123precipe_
precipes143212213precipes
precise113518173precise_
precised133213413precised
precises123218333precises
precited133013813precited
precode12311853precode_
precoded1438863precoded
precodes13711573precodes
predinner1245133predinner
predive13511083predive_
preener93114833pre_ener
prefacer1537983prefacer
prefade1339013prefade_
prefaded1537823prefaded
prefades1439533prefades
prefer113813203pre__fer
prefile123413183prefile_
prefiled143310573prefiled
prefiles133113443prefiles
prefire124012813prefire_
prefired144310753prefired
prefires134313283prefires
prefixed21357703prefixed
prefixes20389233prefixes
preguide1255423preguide_
preguided1443923preguided
preguides1344863preguides
prejudger2042553prejudger
prelife1279953prelife_
prelives13310383prelives
prelude1038013prelude_
preluded1236473preluded
preluders1234423preluders
preludes1137833preludes
premade12311443premade_
premie103617993premi_e_
premiere12249233premi_ere
premiers122911653premi_ers
premies113823063premi_es
premise113818553premise_
premised133013193premised
premises123018273premises
premixed20338013premixed
premixes193110083premixes
premodern1444423premodern
preorders1235403preorders
preparer12169643preparer
preppier1156643preppier
presage10312293presage_
presaged1238813presaged
presagers1236943presagers
presages11312203presages
presale9416353presale_
presales10315263presales
presbyter1643733presbyter
prescinded1644343prescinded
prescore124812373prescore
prescriber1684883prescriber
prese75228383pres__e_
presenter11311643presenter
preserver14127013preserver
preset84430983pres__et
presidency1844653presidency
presidents1347023presidents
presidial1247213presidial
presidiary1653283presidiary
presiding13510903presiding
presidios1245783presidios
presidium1445303presidium
presift12312223presi_ft
presifted1536873presifted
presifts1366603presifts
presleep1244493presleep
preslice1258623preslice_
presliced1435983presliced
preslices1338213preslices
pressed103317313pres_sed
pressers103215023pres_sers
presses93523153pres_ses
pressmen1238833pressmen
pressor93512883pres_sor
pressure1039773pressure
presters103419003pres_ters
prestige11310733prestige_
prestiges12310593prestiges
prestore104217353prestore
presume11310303presume_
presumed1337973presumed
presumers1336373presumers
presumes1239843presumes
pretender1246663pretender
prettier1069043prettier
prevailer1445153prevailer
preview1536473previ_ew
previewer1743023previewer
previse123713803previse_
prevised143611083prevised
previses133814293previses
previsor13116323previsor
prewire124311143prewire_
prewired14358473prewired
prewires133811013prewires
prexies163415003prexi_es
preyer114413733pre__yer
pricer103918293pr__icer
pricier113313113prici_er
pride84724743pr__ide_
prided103618033pr__ided
prides94324183pr__ides
prier75027763pr__i_er
primer105118683pr__imer
prisoner1048573prisoner
prissier10157873prissier
privier122910453privi_er
prizer174714883pr__izer
prodder1147953pr_odder
profiler13287643profiler
profiter132710203profiter
promiser122510673promiser
proser84223463pros__er
prosper114012193pros_per
prouder10310383pr_ouder
provide1339853provide_
provided1536843provided
providers1535593providers
provides1439883provides
pursier94012753pursi_er
pussier93711993pussi_er
raider74318743_r_aider
rapider1067903_rapider
reader73628293_re_ader
readier83117423_readier
reciter94117263_reciter
redder83918143_re_dder
reedier83815303_reedier
refiner105316913_refiner
reiver95318293_re_iver
relier65826183_reli_er
reminder113110513_reminder
render74024143_re_nder
reorder8239483_reorder
repiner94816903_repiner
rescinder1245293_rescinder
rescuer939033_rescuer
resid64124093_resid__
resident9313753_resident
resids74219153_resid_s
residua8286623_residua
residue8689863_residue
residues9338813_residues
resigner937793_resigner
resile64627673_resile_
resiled84621983_resiled
resiles74026543_resiles
resilver11337503_resilver
resined84522653_resined
resister8311653_resister
resite64128453_resite_
resited85122423_resited
resites74027803_resites
resize154117723_resize_
resized174614903_resized
resizes164216843_resizes
resolder9259233_resolder
rester63832433_res_ter
resumer9410113_resumer
retirer74715013_retirer
reviler104314973_reviler
reviser104114673_reviser
reviver134411373_reviver
rewiden1137533_rewiden
rewinder12317663_rewinder
rider65231313_r__ider
rosier64221273_rosi_er
spreader1137483spre_ader
subsider1138253subsider
topsider1144503topsider
treader84113833tre_ader
trendier937913trendier
tressier847963tressier
ureide7310363ure_ide_
ureides8311103ure_ides
wrester102812413wres_ter
wrestler11306993wrestler

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.436409841.7
2DLD Change Limit1461622687.54619369.5
3Display Results2682680.0962791.7
 (SQL Overall)1786912688.07822120.7
 
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.