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 “prater” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

199 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
prater8482535(None) 
crater85026641crater
frater94520591frater
grater74625441grater
irater65218351irater
krater104014311krater
pater74740721p_ater
plater84427691plater
prate75135981prate_
prated94924921prated
praters94921651praters
prates84633161prates
prayer114815291prayer
rater54943281_rater
abater85518122abater
barter85525372barter
beater84729392beater
boater84622092boater
bracer104620582bracer
braver114719042braver
brawer114216332brawer
brayer115315312brayer
brazer174917532brazer
carter84932272carter
cater74840722_cater
coater84329572coater
crafter124111332crafter
crate76537402crate_
crated94827772crated
craters95021892craters
crates85736062crates
craver114618462craver
darter75320362darter
dater65332312_dater
drafter11449422drafter
draper94315692draper
drawer104711362drawer
eater54639842_eater
elater64724202elater
eraser64216332eraser
feater95224052feater
framer114817442framer
fraters103517212fraters
garter74420512garter
gater64533652_gater
grader84919692grader
grafter114211152grafter
granter84117132granter
grate64932882grate_
grated84523922grated
graters85419742graters
grates75429892grates
graver105018592graver
grayer106014542grayer
grazer164815762grazer
greater84416492greater
hater85034752_hater
heater94828302heater
irate55627982irate_
kraters114212342kraters
later54843922_later
mater74438862_mater
neater64424312neater
oater55433732_oater
orate55133302orate_
orated74221502orated
orates64328612orates
orator6314532orator
pacer96131612p_acer
pager84728202p_ager
paler75436932p_aler
palter84423262palter
paper95128662p_aper
parader103914862parader
parer75839902p_arer
parker124121372parker
parser84822372parser
parted94228682parted
partier93520712partier
partner92811392partner
partyer12337872partyer
paster85734372paster
pate65350462p_ate_
pated85237842p_ated
paten74827342p_aten
paters84935832p_aters
pates76047892p_ates
patter84628262patter
patzer173111642p_atzer
paver104225832p_aver
pawer104422972p_awer
payer105125722p_ayer
pearter9412742pearter
peatier94017232peatier
pelter83321622pelter
perter84422282perter
pester84827592pester
peter74427592p_eter
petter83924772petter
pewter114013672pewter
phatter123810202phatter
piaster93012882piaster
pirate82322882pirate_
pirated102515612pirated
pirates93020332pirates
placer105117742placer
plaiter93615392plaiter
planer84122652planer
planter94017802planter
plaster93318692plaster
plate74635112plate_
plated95225772plated
platen84518202platen
platers93924092platers
plates85432242plates
platier93716292platier
platter93917412platter
player115215212player
pleater93916332pleater
porter84224412porter
poster84129172poster
potter83926982potter
pouter83923982pouter
powter114116032powter
praetor938972praetor
praiser93413942praiser
prancer113613382prancer
prase76128752prase_
prases84429022prases
prat65952042prat__
prats76333392prat_s
prattler10166342prattler
prawner1246802prawner
praxes156215182praxes
prayed124815432prayed
prayers124212852prayers
prealter1048862prealter
preaver121011612preaver
prefer113813202prefer
prester93519622prester
preterm11310152preterm
pretor8315742pretor
preyer114413732preyer
pricer103918292pricer
prier75027762pr_ier
primer105118682primer
printer93917302printer
privater13158532privater
prizer174714882prizer
prober104516072prober
proper104319952proper
proser84223462proser
protea82214762protea
protei82615312protei
prover113819722prover
prower114218122prower
pruner83413452pruner
pryer104415312pr_yer
psalter9247812psalter
punter84320022punter
putter83921442putter
racer75233022_racer
rafter94517582_rafter
raker94529792_raker
ranter63826822_ranter
raper74932752_raper
rarer54731702_rarer
raser55633412_raser
raster64731442_raster
rate45458762_rate_
rated65441382_rated
ratel54224882_ratel
raters63936582_raters
rates55352012_rates
rather94319742_rather
ratter64326312_ratter
raver85631492_raver
rawer84623732_rawer
razer144824272_razer
seater64534152seater
skater105015492skater
slater64429182slater
sprayer12369042sprayer
stater64427562stater
tarter64023562tarter
tater54138612_tater
tracer84820232tracer
trader75218762trader
treater74219832treater
triter65120592triter
updater10347252updater
uprate83916542uprate_
uprated103213322uprated
uprates93814862uprates
urate55432162urate_
urates65027762urates
ureter6313202ureter
water84733312_water
writer94416512writer

Search took 3 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 Filter178691825510.1101624463.6
2DLD Change Limit825511992.17337989.4
3Display Results1991990.0603316.7
 (SQL Overall)1786911992.34376265.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.