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

210 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
prated9492492(None) 
crated94827771crated
grated84523921grated
orated74221501orated
parted94228681parted
pated85237841p_ated
pirated102515611pirated
plated95225771plated
prate75135981prate_
prater84825351prater
prates84633161prates
prayed124815431prayed
rated65441381_rated
uprated103213321uprated
abated95918452abated
aerated85322382aerated
alated75625152alated
aurated83817792aurated
bated85935532_bated
berated104422132berated
boated94221972boated
borated104116362borated
braced115420602braced
bracted12410932bracted
braked135318692braked
braved124817442braved
brayed124615782brayed
brazed184717082brazed
bruted95113262bruted
carted98631442carted
cerated103922472cerated
coated94927042coated
crafted13419772crafted
craned96121652craned
craped116120532craped
crate76537402crate_
crater85026642crater
crates85736062crates
craved125417772craved
crazed184714452crazed
created104323462created
curated104717582curated
darted84620922darted
dated75530992_dated
derated93623502derated
doated84118182doated
drafted12439032drafted
draped105314362draped
dratted9358592dratted
drayed115911392drayed
elated74725822elated
erased74816762erased
farted105121782farted
fated95632132_fated
fracted1339372fracted
framed125116522framed
frater94520592frater
frayed135012162frayed
gated75329772_gated
graced105217902graced
graded94919552graded
grafted124110222grafted
granted94715102granted
grate64932882grate_
grater74625442grater
grates75429892grates
graved114818812graved
grayed115415642grayed
grazed174115912grazed
gyrated12428412gyrated
hated95734022_hated
heated104525592heated
irate55627982irate_
irater65218352irater
krater104014312krater
lated65240672_lated
lyrated11388472lyrated
marted94425212marted
mated85537782_mated
meated94222402meated
moated94819002moated
operated11512222operated
opiated1039482opiated
orate55133302orate_
orates64328612orates
paced106931682p_aced
paged95926782p_aged
paled85538722p_aled
paned85437182p_aned
panted95024822panted
paraded114014262paraded
pared86946762p_ared
parged104922042parged
parked134425142parked
parled94626292parled
parred95024072parred
parsed96323892parsed
partied103516552partied
pasted94426902pasted
pate65350462p_ate_
paten74827342p_aten
pater74740732p_ater
pates76047892p_ates
patted94724682patted
paved115525262p_aved
pawed115725612p_awed
payed115925932p_ayed
peaced115818912peaced
peaked136117402peaked
pealed95322812pealed
pelted94617762pelted
petted94121522petted
phased124011972phased
phrased1387382phrased
picrated132110112picrated
pirate82322882pirate_
pirates93020332pirates
pitted94319592pitted
placed114318002placed
plaited103713892plaited
planed94420912planed
planted103516122planted
plate74635112plate_
platen84518202platen
plater84427692plater
plates85432242plates
platted103614262platted
played124815032played
pleated103816632pleated
ported94223242ported
posted93722492posted
potted94624012potted
pouted94021392pouted
praised104214812praised
pranced123714042pranced
pranged114512552pranged
pranked143712092pranked
prase76128752prase_
prases84429022prases
prat65952042prat__
praters94921652praters
prats76333392prat_s
prattled11246532prattled
prawned1346742prawned
praxes156215182praxes
prayer114815292prayer
preacted132710942preacted
preaged11612332preaged
predated12513272predated
preed85128122pr_eed
premed114617762premed
pretend104011012pretend
preyed125313202preyed
priced115018882priced
prided103618032prided
pried84426862pr_ied
primed115118912primed
printed104016372printed
prised94322202prised
prized184415392prized
probated13410862probated
probed114114822probed
pronated11414052pronated
prorated11513712prorated
prosed94921102prosed
protea82214762protea
protei82615312protei
proteid103513672proteid
protend104012792protend
proved125016032proved
pruned93413112pruned
punted94618712punted
pupated12319352pupated
putted94220252putted
raced87635312_raced
rafted104714702_rafted
raged74829452_raged
raked105831422_raked
ranted74324702_ranted
raped85334622_raped
rared65738322_rared
rased65033932_rased
rate45458762_rate_
ratel54224882_ratel
rater54943282_rater
rates55352012_rates
ratted74923342_ratted
raved94931432_raved
raxed135622662_raxed
rayed95127502_rayed
razed155027982_razed
sated66238532_sated
seated75131062seated
skated114414882skated
slated75028312slated
sprayed13398902sprayed
stated75427832stated
tarted74923372tarted
teated74924022teated
traced94821582traced
traded85717682traded
treated83618702treated
unrated82621552unrated
updated11369422updated
uprate83916542uprate_
uprates93814862uprates
urate55432162urate_
urates65027762urates
warted104223232warted
wrathed14298522wrathed

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.373479064.3
2DLD Change Limit825512102.51632810.4
3Display Results2102100.0633333.3
 (SQL Overall)1786912102.95260532.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.