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

363 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
pretties1061513(None) 
prettied1159251prettied
prettier1069041prettier
prettiest1199801prettiest
frettier1156592frettier
frettiest1267062frettiest
jetties143613122_jetties
patties93425142p_atties
petites93820202p_etites
pettier94213612p_ettier
pettiest103113962p_ettiest
pettles93916482p_ettles
pieties9419222pie_ties
plenties10314692plenties
plotties103111412plotties
poetries10315582poetries
potties93723542p_otties
prattles10189402prattles
predries112714382predries
preemies12512192preemies
premies113823062pre_mies
prentices131111902prentices
preppies1149682preppies
prestiges12310592prestiges
pretapes122811532pretapes
pretrims1238982pretrims
prettifies1545692prettifies
prettify1644342prettify
prettily1337272prettily
prettiness1257392prettiness
pretypes15337262pretypes
prexies163415002pre_xies
proettes10312762proett_es
prosties101421192prosties
putties94420022p_utties
reties65436192_re_ties
retries74129072_retries
treaties8316982treaties
appetites1347513appetites
arenites8917103arenites
aretes64425353are_t_es
ariettes8411353ariett_es
arteries8321463arteries
brattices1345553brattices
brattier1047663brattier
brattiest1148103brattiest
brattles10199333brattles
breathes134212903breathes
brevities1446423brevities
brittles10178653brittles
burettes1048943burett_es
butties93217953_butties
catties94023053_catties
chitties13310773chitties
creates95225173creat_es
creatines112814433creatines
creatins103617513creatins
creatives14279693creatives
creepies1239613creepies
cretics112911653cre_tics
cretins93216423cre_tins
cruelties1144893cruelties
curettes1039313curett_es
cutties93118843_cutties
deities82621923_deities
ditties83116983_ditties
drearies92313413drearies
eremites10312593eremites
fatties103018203_fatties
ferities111416713ferities
fettles103912733_fettles
freebies1337873freebies
frenzies2037713frenzies
fretted113411853frett_ed
fretter103412753frett_er
fretters113410303fretters
fretting122711523fretting
ghettoes1243493ghettoes
greenies9312673greenies
gremmies1355993gremmies
grittier9316263grittier
grittiest10176983grittiest
grottier9316673grottier
grottiest10147183grottiest
grottoes9276753grottoes
hotties103016953_hotties
jettied15366973_jettied
jettier14358693_jettier
jettiest15359593_jettiest
jutties143814003_jutties
kettles113411613_kettles
kitties113213623_kitties
lefties10312073_lefties
mettles94115023_mettles
nettier74211813_nettier
nettiest83112433_nettiest
nettles73214083_nettles
palettes103112833palett_es
panties94230933p_anties
pantries101817393pantries
paretics122312443pare_tics
parities10522973parities
parkettes15137593parkett_es
parties93230863p_arties
pasties94529813p_asties
pastries101517423pastries
patsies93919483p_atsies
pattie84020963p_attie_
peatier94017233p_eatier
peatiest103118803p_eatiest
peavies122213393p_eavies
pectines121914673p_ectines
pectins112315233p_ectins
pectizes21229773p_ectizes
peeries93623023p_eeries
pelites93821993p_elites
peltries10313023peltries
pennies94218813p_ennies
peonies93620153p_eonies
peptics132610243p_eptics
peptides132610263p_eptides
peptids12239323p_eptids
peptizes21269853p_eptizes
perlites10316353perlites
perries93226603p_erries
pertains102113413pertains
pestier94317403p_estier
pestiest103018413p_estiest
pestles93217693p_estles
petite84320653p_etite_
petted94121523p_ett_ed
petter83924773p_ett_er
petters93722363p_etters
petti75119453p_etti__
pettily1238173p_ettily
pettiness1178703p_ettiness
petting103720953p_etting
pettings11349703p_ettings
pettish1238283p_ettish
pettitoes1144173p_ettitoes
pettle84116053p_ettle_
pettled103611503p_ettled
phratries1447583phratries
phrensies1445743phrensies
pigsties1139783pigsties
pipettes1237563pipett_es
pities83828083p__ities
platies93722543p_laties
plottier10327263plottier
plottiest11287833plottiest
poesies93217403poe_sies
poetics11312073poe_tics
poetise9314043poe_tise
poetises10313953poetises
poetizes19310253poetizes
polities102722343polities
posties93128813p_osties
potpies113116173p_otpies
potsies93019483p_otsies
pottier93516493p_ottier
pottiest102815973p_ottiest
pottles93816983p_ottles
poverties1439513poverties
practices1557993practices
practise12310143practise
practises1349623practises
prairies10411453prairies
prates84633163pr_at_es
prattle9208833prattle_
prattled11246533prattled
prattler10166343prattler
prattlers11195323prattlers
preaches153214893preaches
preattunes1243973preattunes
prebakes1639003prebakes
prebids12399883pre_bids
preboils1267293preboils
precedes13310703precedes
precipes143212213precipes
precis103416703pre_ci_s
precise113518173pre_cise
precises123218333precises
precited133013813precited
precodes13711573precodes
precures12312903precures
predates11615803predates
predried12309573predried
preedits1168763preedits
preemie11310563preemie_
prees75937173pre___es
prefaces15311063prefaces
prefades1439533prefades
prefiles133113443prefiles
prefires134313283prefires
prefixes20389233prefixes
pregames1339003pregames
preguides1344863preguides
prelacies13310043prelacies
prelates10418563prelates
prelims1139823pre_lims
prelives13310383prelives
preludes1137833preludes
premie103617993pre_mie_
premier113515633pre_mier
premiers122911653pre_miers
premise113818553pre_mise
premises123018273premises
premiss113513813pre_miss
premixes193110083premixes
prenames12311633prenames
prentice121012353prentice
prenticed14118063prenticed
prepares122014163prepares
prepaves15189193prepaves
preppie1058093preppie_
preppier1156643preppier
preppiest1236973preppiest
preprices1569263preprices
prepubes1436053prepubes
prepuces1438583prepuces
presages11312203presages
presales10315263presales
presettles1245013presettles
preships1539313preships
presides11414913presides
preslices1338213preslices
presses93523153pre_sses
prester93519623prest_er
presters103419003presters
prestige11310733prestige
prestores114716073prestores
prestos93716083prest_os
prestress1138133prestress
prests84021263prest__s
presumes1239843presumes
pretape113511623pretape_
pretaped13339133pretaped
pretastes11119423pretastes
preteen939873pre_teen
preteens1038123preteens
pretells1047323pretells
pretences132312603pretences
pretends11299113pretends
pretense10199813pretense
pretenses112210583pretenses
preterites12411783preterites
preterits11410943preterits
preterms1237223preterms
pretest9517633pre_t_est
pretests10310013pretests
pretexts1735603pretexts
pretors9316803pre_tors
pretrains11410143pretrains
pretrial10511983pretrial
pretrials1158143pretrials
pretrim11310773pretri_m
prettified1644943prettified
prettifier1543973prettifier
prettifiers1642513prettifiers
pretty11510873prett__y
prettying1536043prettying
prettyish1743053prettyish
pretype14387483pretype_
pretyped16306123pretyped
pretzel1835143pre_tzel
pretzels1934033pretzels
preunites1138933preunites
prevails1337663prevails
preview1536473pre_view
previews1634513pre_views
previse123713793pre_vise
previses133814283previses
prevues1239263pre_vues
prewires133811013prewires
prexes154915943pre__xes
prezes173614693pre__zes
pries74339533pr___ies
priories10312453priories
prissies101712003prissies
privies122414263pr_ivies
privities14312033privities
probities13312653probities
proette9312363proett_e_
properties141411883properties
prossies101515223prossies
prostie91617743prostie_
protases102115033protases
proteges1149923proteges
proteides12238783proteides
proteids11259943proteids
proteins102114283proteins
protyles13249833protyles
proxies163014933pr_oxies
puberties1346603puberties
punties94520783p_unties
purities10316283purities
puttees93612913p_uttees
puttie84116303p_uttie_
puttied103811163p_uttied
puttier93314503p_uttier
puttiers10288013p_uttiers
ratites74920683_ratites
rattier74015593_rattier
rattiest83516113_rattiest
rattles73217303_rattles
readies83324703_readies
realties8514853_realties
recites93524583_recites
redries83721713_redries
reflies104418533_reflies
refries104419733_refries
reifies104218283_reifies
relies65036423_re_lies
rentes65431193_rent_es
rentier73618223_rentier
rentiers83311763_rentiers
replies94521043_replies
reptiles103913063_reptiles
resites74027793_resites
retails74718973_retails
retains74522253_retains
retakes113718863_retakes
retapes93917423_retapes
retaxes143615093_retaxes
retches123318513_retches
retenes76324623_retenes
retie55735303_re_tie_
retied75924983_re_tied
retiles74426993_retiles
retimes95020173_retimes
retines75134673_retines
retires74726213_retires
retitles83612593_retitles
retried84419153_retried
retrims93612373_retrims
retted74826313_rett_ed
retting83425883_retting
retunes76918403_retunes
retypes12308623_retypes
rottes64524833_rott_es
ruttier73412283_ruttier
ruttiest82712663_ruttiest
scotties1039733scotties
settees73513633_settees
settles73916003_settles
shelties111111373shelties
sprattles1174883sprattles
sureties8316583sure_ties
sweeties11159723sweeties
syrettes1136963syrett_es
tatties74120343_tatties
titties73617363_titties
treatise8311103treatise
treatises9310373treatises
trendies9312213trendies
trestles83012553trestles
trusties82712853trusties
tutties73216473_tutties
twenties1137503twenties
verities111418043verities
wreathes14299893wreathes
wrestles113310063wrestles
wretches16257283wretches

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.1701051123.5
2DLD Change Limit1461623638.31317582.3
3Display Results3633630.1562326.9
 (SQL Overall)1786913638.63920684.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.