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

192 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
pretends1129911(None) 
prebends13347881prebends
pretend104011011pretend_
protends113010351protends
perpends13227752perpends
portends11358962portends
prebend12319442prebend_
prebinds13357732prebinds
precents123015042precents
preens85020112pre_en_s
prefunds1454692prefunds
premeds12389592preme_ds
presents103315642presents
preteens1038122preteens
pretells1047332pretells
pretence122312122pretence
pretences132312612pretences
pretended1337192pretended
pretender1246662pretender
pretenders1345242pretenders
pretense10199822pretense
pretenses112210592pretenses
preterms1237222preterms
pretests10310012pretests
pretexts1735602pretexts
prevents133012292prevents
propends13249172propends
proteids11259942proteids
protend104012792protend_
relends84013252_relends
remends105013032_remends
resends83513712_resends
retenes76324622_retenes
apprehends1852503apprehends
aretes64425353arete__s
attends8257593_attends
bartends1136793bartends
breeds94914883bre_e_ds
coextends1942323coextends
contends112810573contends
credenda1243393credenda
creeds94714773cre_e_ds
cretins93216423cretin_s
defends12358773_defends
depends11348993_depends
detents83615153_detents
distends10339823distends
emends95711433__emends
extends15227113_extends
forefends1644493forefends
friends11396743fr_iends
greatens9307593greaten_s
greeds84314283gre_e_ds
greens75716873gre_en_s
intends8239963_intends
ketenes114813503_ketenes
legends936073_legends
mistends11419593mistends
patens84820863p_aten_s
patents94815203p_atents
pattens95414923patten_s
pectens11189203pecten_s
peens76428193p_e_en_s
pends85527193p___ends
pentenes10315633pentenes
percents122713373percents
perpend12259353perpend_
perpents122312043perpents
pertness10310093pertness
petards104311153p_etards
peters86624593p_ete_rs
platens94213983platen_s
poetess938933poete_ss
portend103411193portend_
portents103512823portents
poteens92910883poteen_s
prated94924923prate_d_
praters94921653prate_rs
prates84633163prate__s
prebendal1444003prebendal
prebids12399883pre_bids
prebind123810643prebind_
precede1239653prece_de
precedes13310713precedes
precent113520263precen_t
precepts14268893precepts
precess11310863prece_ss
preed85128123pre_e_d_
preen75925053pre_en__
preened103214993pre_ened
preener93114833pre_ener
preeners102712813pre_eners
prees75937173pre_e__s
prefects1598133prefects
prefers123713333prefe_rs
prefund1335733prefund_
preheats1339413preheats
prelects1299723prelects
preloads1157513preloads
premed114617763preme_d_
premen105017803premen__
premolds1345843premolds
prepense12238943prepense
prerenal1049083prerenal
prescinds1444953prescinds
presells1058283presells
presence122213513presence
presences132113793presences
present94022733presen_t
presets94216423prese_ts
presters103419003preste_rs
pretapes122811533pretapes
preteen939873prete_en
pretell938243prete_ll
pretending1438613pretending
preterit10315843preterit
preterits11410963preterits
preterm11310163prete_rm
pretest9517633prete_st
pretext1639663prete_xt
pretold1049083pretold_
pretors9316813pret_ors
pretreats1146933pretreats
pretrims1238983pretrims
pretties10615133pretties
pretypes15337263pretypes
pretzels1934033pretzels
prevent124016553preven_t
preverbs15295303preverbs
prexes154915953prexe__s
preyed125313203preye_d_
preyers124412363preye_rs
prezes173614693preze__s
probands13228393probands
proceeds1335983proceeds
propend123311273propend_
propenes122816513propenes
proteans102811543proteans
proteas92015123prote_as
protects1239743protects
proteges1149923proteges
proteid103513673proteid_
proteide11239723proteide
proteides12238783proteides
proteins102114283proteins
protended1336803protended
protests10310493protests
proteus92511593prote_us
protons93118003proton_s
rebinds104511873_rebinds
reblends1135293_reblends
reeds65430903_re_e_ds
refeeds11368973_refeeds
refinds114512123_refinds
refunds11448623_refunds
regents83416543_regents
relands85214883_relands
relend76116453_relend_
relents74018503_relents
remands104914883_remands
remend95216553_remend_
reminds104614793_reminds
rends65129953_r__ends
repents93717623_repents
repetends1244003repetends
reprehends1643283reprehends
rereads81512293_rereads
rerents73319423_rerents
reseeds84012333_reseeds
resend75016773_resend_
resents74221223_resents
retards85015003_retards
reteams9339563_reteams
retears72814923_retears
retells73211523_retells
retems83914573_rete_ms
retene69224273_reten_e
retests73813853_retests
retinas74819353_retinas
retines75134673_retines
retints74717013_retints
retreads937823_retreads
retunes76918403_retunes
reweds104412303_rewe_ds
rewelds11457413_rewelds
rewinds114810483_rewinds
subtends1136173subtends
tends65425583___tends
treens65317873tre_en_s
trends75513543tr__ends
ureters7311823urete_rs
weekends1642733weekends

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.423422437.4
2DLD Change Limit1461621927.28020077.2
3Display Results1921920.0802400.0
 (SQL Overall)1786911927.78322959.1
 
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.