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

376 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
presales1031526(None) 
presages11312201presages
presale9416351presale_
resales74724901_resales
percales12313802percales
persalts1038192persalts
pesades10310902p_esades
pestles93217692p_estles
prebakes1639012prebakes
predates11615812predates
prefaces15311062prefaces
prefades1439532prefades
prefiles133113442prefiles
pregames1339002pregames
prelates10418572prelates
prenames12311642prenames
prepares122014162prepares
prepaves15189192prepaves
presage10312292presage_
presaged1238802presaged
presager1138442presager
presagers1236942presagers
presells1058282presells
preshapes1667092preshapes
presides11414912presides
presolves1456532presolves
presses93523152pres_ses
presumes1239842presumes
pretapes122811532pretapes
prevalues1445322prevalues
reales64934122_re_ales
regales83520792_regales
resale64025542_resale_
rescales103414572_rescales
resiles74026542_resiles
resoles73823652_resoles
trestles83012552trestles
wrestles113310062wrestles
amesaces1246693amesaces
areoles71016953are_oles
brewages1436383brewages
bristles101510433bristles
creases94020963cre_ases
creates95225203cre_ates
cremates124216003cremates
creoles9913323cre_oles
cresols939653cresol_s
cresses94219813cres_ses
crestless1146783crestless
cresyls1234753cresyl_s
crevalles1455723crevalles
crusades1146333crusades
desalts839573_desalts
dressages1144153dressages
dresses83716173dres_ses
females12310663_females
freckles17126383freckles
frescoes1357833frescoes
freshes133515823fres_hes
fresnels1135233fresnels
greases84816713gre_ases
greaves113311443gre_aves
grenades1038433grenades
gristles9189203gristles
measles92412753_measles
nestles73015463_nestles
oversales12313143oversales
paesanos10296703paesanos
paesans93312693paesa_ns
pales75753803p___ales
pareses94718883pares__es
passades1139203passades
passages1139513passages
peaces106324083p_e_aces
peages94321853p_e_ages
pealed95322813p_e_aled
peals75235493p_e_al_s
peases85229473p_e_ases
pebbles1337573p_ebbles
pedaled113711893p_edaled
pedaler103410693p_edaler
pedalers11239393p_edalers
pedalos10329703p_edalos
pedals94316033p_edal_s
peddles112913703p_eddles
peerages1189893peerages
pelages10714613p_elages
peles75738083p_e__les
penates93321603p_enates
peoples11312223p_eoples
percale11314093percale_
persalt9315413persal_t
perses85428063pers__es
persuades1245623persuades
perusals1047143perusal_s
pervades1437353pervades
pesade9311103p_esade_
pestle83215843p_estle_
pestled102711453p_estled
petaled103614153p_etaled
petals84719813p_etal_s
petrales10312983petrales
pettles93916483p_ettles
phenates13611583phenates
piebalds1344343piebalds
pieholes13168913pieholes
pinwales1367963pinwales
pleases94515483ple_ases
pleiades1145753pleiades
poesies93217403poes_ies
posoles9314883p_osoles
prases84429023pr__ases
prates84633163pr__ates
prattles10189403prattles
praxes156215183pr__axes
preaches153214893preaches
preacts113211363pre_acts
preaged11612333pre_aged
prealter1048863pre_alter
prealters1147773pre_alters
preambles1545333preambles
preamps1336613pre_amps
prearms11369173pre_arms
preaver121011613pre_aver
preavers13910263pre_avers
prebade12310283prebade_
prebake1539093prebake_
prebaked1737173prebaked
prebills1237293prebills
prebless1236823pre_bless
precasts1239453precasts
precedes13310713precedes
precipes143212213precipes
precises123218333precises
precodes13711573precodes
precures12312903precures
predate10616893predate_
predated12513273predated
predawns1444363predawns
predries112714383predries
preemies12512193preemies
prees75937173pre___es
prefabs1435163prefa_bs
preface14510923preface_
prefaced1638423prefaced
prefacer1537983prefacer
prefacers1636293prefacers
prefade1339013prefade_
prefaded1537823prefaded
prefile123413183prefile_
prefiled143310573prefiled
prefires134313283prefires
prefixes20389233prefixes
pregame1239553pregame_
prehandles1644183prehandles
prelacies13310053prelacies
prelate9519693prelate_
prelives13310383prelives
preludes1137833preludes
premade12311443premade_
premies113823063pre_mies
premises123018273premises
premixes193110083premixes
premolds1345843premolds
prename11412643prename_
prepacks1836583prepacks
prepare111913623prepare_
prepared132210873prepared
preparer12169643preparer
preparers13197673preparers
prepastes13128823prepastes
prepave14228873prepave_
prepaved16177233prepaved
prepays1437483prepa_ys
preplaces1578753preplaces
preplans1249613preplans
preppies1149693preppies
prepubes1436053prepubes
prepuces1438583prepuces
prequels1934833prequels
prerace11414123prerace_
presa74319043presa___
prescores133912173prescores
prese75228383pres__e_
preselect1346983preselect
preselects1464363preselects
presell939303presel_l
presences132113793presences
presents103315643presents
preserves14109073preserves
preset84430983pres__et
presets94216423pres_ets
presettles1245023presettles
preshape1537533preshape_
preshaped1745523preshaped
preships1539313preships
preshows16267023preshows
preside10715613preside_
presided12410553presided
presider11410423presider
presiders1248213presiders
presifts1366593presifts
presleep1244493presleep
preslices1338213preslices
presoaked1635653presoaked
presoaks1436603presoaks
presold1059603presol_d
presolve1347073presolve
presolved1545273presolved
presorts105311683presorts
presplit1247753presplit
press75425953pres___s
pressed103317313pres_sed
presser93717623pres_ser
pressers103215023pressers
pressmen1238833pressmen
pressors103212693pressors
pressures1149063pressures
prestamps1543523prestamps
prester93519623pres_ter
presters103419003presters
prestiges12310593prestiges
prestores114716083prestores
prestos93716083pres_tos
prestress1138133prestress
prests84021263pres__ts
presume11310303presume_
presumed1337973presumed
presumer1247583presumer
presumers1336373presumers
pretape113511623pretape_
pretaped13339133pretaped
pretastes11119423pretastes
pretells1047333pretells
pretties10615133pretties
pretypes15337263pretypes
pretzels1934033pretzels
prevailed1536043prevailed
prevailer1445153prevailer
prevailers15123833prevailers
prevails1337663prevails
prevalent14128063prevalent
prevalents1594973prevalents
prevalue1345073prevalue
prevalued1544553prevalued
previses133814283previses
prevues1239263pre_vues
prewarms15406733prewarms
prewarns13456943prewarns
prewashes1744753prewashes
prewires133811013prewires
prexes154915953pre__xes
prexies163415003pre_xies
prezes173614693pre__zes
prickles162511093prickles
primages13159273primages
primates121515933primates
priseres10310823priseres
prises84133173pris__es
prisses94816713pris_ses
prissies101712003prissies
pristanes11410433pristanes
privates131812373privates
probables1545433probables
probates12414283probates
profanes132311573profanes
profiles133211233profiles
proles84627203pr__oles
pronates10418373pronates
propanes122415823propanes
prorates10418073prorates
proses84733473pros__es
prosses94019513pros_ses
prossies101515223prossies
prostates11314423prostates
prosties101421193prosties
prostyles14157113prostyles
protases102115033protases
protyles13249833protyles
psalms1045673p__salms
pulsates1048813pulsates
quezales2643463quezales
rales54947493_r__ales
rassles73513923_rassles
realer63528593_re_aler
realest73322433_re_alest
realms84913493_re_alms
reals55038653_re_al_s
reaves94127573_re_aves
rebates95123183_rebates
recalls92613623_recalls
recanes93222263_recanes
redates83423873_redates
reddles93315773_reddles
refaces123216743_refaces
refalls103312243_refalls
refiles104122423_refiles
regale74821453_regale_
regaled93615963_regaled
regaler83814623_regaler
regalers94311133_regalers
relaces93420883_relaces
relates73731433_relates
relaxes143215323_relaxes
remakes134116173_remakes
remates93827113_remates
renames92418053_renames
repaves123513653_repaves
resaddles11114693_resaddles
resailed93613063_resailed
resails74616743_resails
resalutes947433_resalutes
resamples1344713_resamples
resawed113111183_resawed
resaws93713513_resa_ws
resays93714153_resa_ys
rescale93215473_rescale_
rescaled113311303_rescaled
rescues9312753_rescues
resealed92713973_resealed
reseals73917673_reseal_s
resees63827483_res_ees
resells73313203_resells
reshapes1338803_reshapes
reshaves1438733_reshaves
reshes94124363_res_hes
reshoes102316033_reshoes
resides84523283_resides
resile64627673_resile_
resiled84621983_resiled
resites74027793_resites
resizes164216843_resizes
reslates83619503_reslates
resole64624183_resole_
resoled84119283_resoled
resolves113010783_resolves
respaces12311043_respaces
respades1139853_respades
restables111511423_restables
restages92815773_restages
restates83423433_restates
restless82713163_restless
restyles1139193_restyles
results739833_results
resumes9313373_resumes
retables101712673_retables
retakes113718863_retakes
retapes93917423_retapes
retaxes143615093_retaxes
retiles74426993_retiles
reusables1175223_reusables
revalues1137883_revalues
reviles104421353_reviles
rewakes144614983_rewakes
rewaxes173911333_rewaxes
rustles73416413_rustles
sales56055593___sales
sesames9310743_sesames
subsales10310123subsales
supersales12411243supersales
treacles1039703treacles
treadles939703treadles
trebles9311443tre_bles
treddles1036263treddles
trehalas1144883trehalas
trembles1237353trembles
tressels8367653tressels
tresses73719543tres_ses
trestle72611363trestle_
ureases74416723ure_ases
wrassles11376713wrassles
wrastles11328933wrastles
wrestle10298843wrestle_
wrestled12296763wrestled
wrestler11306993wrestler
wrestlers12306103wrestlers

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.516346300.4
2DLD Change Limit1461623767.83018666.9
3Display Results3763760.1532457.5
 (SQL Overall)1786913768.49921024.9
 
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.