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 “pretexts” 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
pretexts173560(None) 
pretests10310011pretests
pretext1639661pretext_
precents123015042precents
precepts14268892precepts
prefects1598132prefects
preheats1339412preheats
prelects1299722prelects
presents103315642presents
presets94216422prese_ts
preteens1038122preteens
pretells1047332pretells
pretends11299112pretends
preterits11410962preterits
preterms1237222preterms
pretest9517632pretest_
pretexted19135692pretexted
pretreats1146932pretreats
prevents133012292prevents
protects1239742protects
protests10310492protests
retests73813852_retests
urtexts1433142ur_texts
aretes64425353arete__s
brevets12519393breve_ts
contexts17378653contexts
detects104011093_detects
detents83615153_detents
detests83711743_detests
greets75117423gre_e_ts
hypertexts2554313hypertexts
patents94815203p_atents
peetweets1442013peetweets
percents122713373percents
percepts14247643percepts
perfects15107353perfects
perpents122312043perpents
pertest9317043pertest_
perverts1337533perverts
peters86624593p_ete_rs
pietists1038323pietists
poetess938933poete_ss
portents103512823portents
praefects1642873praefects
praelects1354353praelects
praters94921653prate_rs
prates84633163prate__s
preacts113211363pre_acts
prebends13347883prebends
precasts1239453precasts
precedes13310713precedes
precent113520263precent_
precept133112513precept_
precess11310863prece_ss
precuts111710473pre_cuts
predeath1447003predeath
predeaths1544743predeaths
predicts1339613predicts
preedits1168763preedits
preelects1356083preelects
preempts1444543preempts
preens85020113pre_e_ns
preerects1345413preerects
prees75937173pre_e__s
preexist1747963pre_exist
preexists1844733pre_exists
prefect141011073prefect_
prefers123713333prefe_rs
prefixes20389233prefixes
preheat12413893preheat_
prelect111013833prelect_
premeds12389593preme_ds
premeet11615153premeet_
premixes193110083premixes
premixt183510663premixt_
presells1058283presells
present94022733present_
preset84430983prese_t_
presifts1366593presifts
presorts105311683presorts
presters103419003preste_rs
prests84021263pr__ests
pretapes122811533pretapes
pretaste10139523pretaste
pretastes11119423pretastes
pretax152310193pretax__
preteen939873prete_en
pretell938243prete_ll
pretence122312123pretence
pretences132312613pretences
pretend104011013prete_nd
pretense10199823pretense
pretenses112210593pretenses
preterit10315843preterit
preterite11613203preterite
preterites12411793preterites
preterm11310163prete_rm
pretermits1445033pretermits
pretested12149113pretested
pretexting20206973pretexting
pretors9316813pret_ors
pretreat10311923pretreat_
pretrims1238983pretrims
pretties10615133pretties
pretty11510873pret__ty
pretypes15337263pretypes
pretzels1934033pretzels
prevent124016553prevent_
preverbs15295303preverbs
prexes154915953pr__exes
preyers124412363preye_rs
prezes173614693preze__s
priests93810863pr_iests
privets122910053prive_ts
projects1936413projects
projets1639163proje_ts
prosects1239473prosects
proteans102811543proteans
proteas92015123prote_as
protect11313633protect_
proteges1149923proteges
proteids11259943proteids
proteins102114283proteins
protends113010353protends
protest9317533protest_
proteus92511593prote_us
protists10313363protists
recepts113010263_recepts
reests64618893_re_ests
refects124012743_refects
regents83416543_regents
reheats104513523_reheats
rejects163910693_rejects
relents74018503_relents
relets64025673_rele_ts
remeets93712413_remeets
remelts93511493_remelts
renests74014213_renests
repeats94316053_repeats
repents93717623_repents
rerents73319423_rerents
reseats74319583_reseats
resects94115593_resects
resents74221223_resents
resets65427613_rese_ts
retaxes143615093_retaxes
reteams9339563_reteams
retears72814923_retears
retells73211523_retells
retems83914573_rete_ms
retenes76324623_retenes
retest64028453_retest_
retints74717013_retints
retorts76016513_retorts
retreats8311413_retreats
reverts104715043_reverts
revests104413733_revests
revets94022173_reve_ts
rewets94617213_rewe_ts
subtexts1744903subtexts
teletexts1642833teletexts
texts125515043___texts
trevets10499973treve_ts
ureters7311823urete_rs
urtext1337433ur_text_
vertexes18105633vertexes

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.453394461.4
2DLD Change Limit1461621667.39019778.3
3Display Results1661660.0632634.9
 (SQL Overall)1786911667.90622601.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.