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

197 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
preriot931641(None) 
heriot9422342_heriot
patriot9314532patriot
peridot10514242p_eridot
period9314982p_eriod
pierrot948832pierrot
predict12315322predict
premixt183510662premixt
preprint12314182preprint
presift12312222presift
chariot12316213chariot
cheroot12413693cheroot
cheviot1546933cheviot
credit9315193credi_t
ergot65422893__ergot
griot65328413__griot
heriots10312063_heriots
merit7339183_meri_t
merlot83217603_merlot
overhot13411223overhot
parergon1144393parergon
parrot8320663p_arrot
patriots1038053patriots
peerie83617893peeri_e
peeries93623023peeries
peering103520353peering
peewit111110903peewi_t
pereion9312053pereion
pereon83517453p_ereon
peri65636973p_eri__
periapt11313413p_eriapt
peridots1138323p_eridots
perigon1039853p_erigon
peril75425953p_eri_l
perils84121853p_erils
periods10312243p_eriods
periotic12313443p_eriotic
peris75537073p_eri_s
perish114619063p_erish
periti8319953p_eriti
permit10321683p_ermit
pernio8513143pernio_
pernod9310453p_ernod
perries93226603perries
perron83216623p_erron
persist9315853persist
person83517873p_erson
pert66759323p_er__t
petit74332653p_eti_t
pewit104622793p_ewi_t
pierrots1044963pierrots
pietist9414033pietist
plenist9314333plenist
pokeroot1447703pokeroot
postriot10412253postriot
preact103220393pre_act
preadopt1348313preadopt
preallot1047033preallot
prebid113512843prebi_d
prebids12399883prebids
prebill1138803prebill
prebind123810643prebind
prebiotic1545413prebiotic
prebirth1543463prebirth
preboil1148953preboil
prebook1557523prebook
preboom1348253preboom
prebuilt1247033prebuilt
precast11314853precast
precent113520263precent
precept133112513precept
precinct1459423precinct
precious12310593precious
precipe133012123precipe
precis103416703preci_s
precise113518173precise
precook1577803precook
precool1139013precool
precut102016533pre_cut
predial103815413predial
predicts1339613predicts
predive13511083predive
predraft1447593predraft
predried12309573predried
predries112714383predries
predrill1145933predrill
preedit10512463preedit
preeing103817673preeing
preempt1337723preempt
preerect1259273preerect
preexist1747963preexist
prefect141011073prefect
prefight1746393prefight
prefile123413183prefile
prefire124012813prefire
prefix18356853prefi_x
preheat12413893preheat
prelect111013833prelect
prelife1279943prelife
prelim10311423preli_m
prelimit1259123prelimit
prelims1139823prelims
premeet11615153premeet
premie103617993premi_e
premier113515633premier
premies113823063premies
premise113818553premise
premiss113513813premiss
premium13310363premium
premix173710333premi_x
premolt11312073premolt
prenoon9310043prenoon
preop94715873pre__op
prepill1147583prepill
preprice1488873preprice
preprints1347473preprints
prerace11414123prerace
preradio1145723preradio_
prerinse1038633prerinse
prerock1536723prerock
prescript1547033prescript
present94022733present
preset84430983pre_set
preshow15237413preshow
preside10715613preside
presifts1366593presifts
presort95219543presort
pressor93512883pressor
prest75736353pre__st
presto84216203presto_
prestos93716083prestos
preterit10315843preteri_t
pretest9517633pretest
pretext1639663pretext
pretor8315753pre_tor
pretreat10311923pretreat
pretrial10511983pretrial
pretrim11310783pretri_m
pretrims1238983pretrims
preunion1046893preunion
prevent124016553prevent
preview1536473preview
previous1337823previous
previse123713793previse
previsit13410073previsit
previsor13116303previsor
prewire124311143prewire
prexies163415003prexies
preying133114553preying
print74837463p__rint
prion75119993p__rion
prior74316173p__rior
probit103218353probi_t
profit113016273profi_t
prosit85124593prosi_t
protist9320223protist
prurient1048233prurient
prurigo1043023prurigo
prurigos1142363prurigos
prutot8311823pr_utot
pterin81014153pteri_n
pterins9812993pterins
puerile9310093puerile
purist85525053p_urist
querist16311133querist
reboot84119333_reboot
recit75235103_reci_t
redipt94116743_redipt
redroot8312903_redroot
refit84230063_refi_t
regilt71217493_regilt
region74614903_region
reknot10311733_reknot
relict83623903_relict
relist64628413_relist
relit55340683_reli_t
remint85329983_remint
remit75737223_remi_t
remixt155014853_remixt
replot83818593_replot
repot75132623_re_pot
reprint9318983_reprint
rerent63832453_rerent
rerig64018483_reri_g
rerigs74014793_rerigs
rerise64325633_rerise
reroof9315003_reroof
reshot93519633_reshot
resift94017723_resift
resist64524533_resist
resit54241043_resi_t
respot83117633_respot
retint65633443_retint
riot45947213___riot
sheroot10414373sheroot
territ63421373terri_t
verist93823893_verist

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271976.34621119.9
3Display Results1971970.0762592.1
 (SQL Overall)1786911976.82826170.3
 
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.