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

148 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
precious1231059(None) 
previous1337821previous
diecious1146872diecious
gracious1138592gracious
pervious1337542pervious
precarious1445502precarious
precieuse1344612precieuse
precieux1943032precieux
preciouses1446882preciouses
preciously1746982preciously
precipes143212212precipes
precis103416702preci__s
precises123218332precises
precocious1644742precocious
precooks1656762precooks
precools1237702precools
precoup1336122prec_oup
predacious1544772predacious
specious1247482specious
araceous1049183araceous
arenous7314183are_nous
arsenious945223arsenious
atrocious1146043atrocious
autecious1145613autecious
capricious1644223capricious
cretinous1145893cretinous
devious1138523_devious
dioecious1244383dioecious
edacious1146023edacious
egregious1143023egregious
erections112515213erections
erectors103514253erectors
ferocious1445193ferocious
fractious1456143fractious
fremitus1344023fremitus
grecizes2035683grecizes
luscious1044853luscious
monecious1376343monecious
parecisms1547163parecisms
pectinous1345553p_ectinous
percoids1339663percoids
pereions10310853pereions
perilous10310693perilous
periods10312243p_eriods
peritus9311803p_eritus
pernicious1445503pernicious
petrous92714423p_etrous
piceous11310693p_iceous
piecings1345343piecings
pious74621273p___ious
pluvious1344443pluvious
poaceous1267173poaceous
praecipes1544853praecipes
prebids12399883prebi_ds
prebills1237293prebills
prebinds13357733prebinds
preboils1267293preboils
prebooks1656303prebooks
precasts1239453precasts
precedes13310703precedes
precents123015043precents
precepts14268893precepts
precess11310863prec_ess
prechills1645123prechills
prechoose16105633prechoose
prechose15129773prechose
precinct1459423precinct
precincts1544993precincts
precipe133012123preci_pe
precipitous1753923precipitous
precise113518173preci_se
precised133213413precised
preciser123411663preciser
precisest13259003precisest
precisions1449373precisions
precited133013813precited
precode12311853prec_ode
precodes13711573precodes
precook1577803prec_ook
precool1139013prec_ool
precrisis1346453precrisis
precures12312903precures
precut102016533prec__ut
precuts111710473prec_uts
predaceous1553943predaceous
predicts1339613predicts
prefiles133113443prefiles
prefires134313283prefires
prefixes20389233prefixes
prefocus1544743prefocus
prelims1139823preli_ms
prelives13310383prelives
premiers122911653premiers
premies113823063premi_es
premises123018273premises
premiss113513813premi_ss
premium13310363premi_um
premiums1437533premiums
premixes193110083premixes
preops104911943pre__ops
preriot9316413prerio_t
prescinds1444953prescinds
preshows16267023preshows
presides11414913presides
presifts1366593presifts
pressors103212683pressors
prestos93716083presto_s
pretors9316803pre_tors
preunions1146483preunions
previews1634513previews
previously1885863previously
previses133814283previses
previsors14126483previsors
prewires133811013prewires
prexies163415003prexi_es
priedieus1242943priedieus
primus103712173pr__imus
prions84317783pr__ions
priors83914483pr__iors
proctors12311513proctors
provirus1345453provirus
pruritus1043943pruritus
recipes113314463_recipes
recites93524583_recites
recits83621353_reci_ts
reckons13269653_reckons
recoils93814873_recoils
recoins94019243_recoins
recons84922993_rec_ons
recooks134711233_recooks
recoup10810373_rec_oup
recoups1188843_rec_oups
recross989833_recross
rectors93520513_rectors
rectos85718783_recto_s
rectus83314633_rec_tus
regions83613473_regions
regius7311923_regi_us
resinous838503_resinous
ricinus9408123_ricinus
rubious938283_rubious
ructious10277083_ructious
serious73616283_serious
spacious1237813spacious
tedious838443_tedious
veracious1447123veracious
vicious1239493_vicious
voracious1445503voracious

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.1561145455.1
2DLD Change Limit1461621488.18617855.1
3Display Results1481480.0632349.2
 (SQL Overall)1786911488.40521260.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.