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

264 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
probated1341086(None) 
probate11414481probate_
probates12414281probates
pronated11414051pronated
prorated11513711prorated
approbated1744762approbated
bromated1339172bromated
globated1265752globated
lobated102610942_lobated
perorated12412452perorated
phonated1447892phonated
prated94924922pr__ated
prebaked1737172prebaked
predated12513272predated
proband122710242proba_nd
probed114114822prob__ed
profaned14207972profaned
profited14279972profited
prolate9419792prolate_
promoted13310542promoted
prompted1536902prompted
pronate9418872pronate_
pronates10418372pronates
prorate9418732prorate_
prorates10418072prorates
rebated103619702_rebated
reprobated1546382reprobated
rotated82715292_rotated
abated95918453__abated
abrogated13126713abrogated
approbate1546563approbate_
approbates1645853approbates
arcuated1138803arcuated
areolated1089713areolated
arointed939003arointed
aroynted1244523aroynted
arrogated11147143arrogated
bated85935533___bated
bilobated1444973bilobated
bloated104513433blo_ated
boated94221973_bo_ated
borated104116363_borated
brocaded1436353brocaded
brocatel1246713brocatel
bromate11313553bromate_
bromates12413143bromates
coated94927043_co_ated
cohobated1744883cohobated
combated1539823combated
coronated123313323coronated
corotated122810053corotated
crated94827773cr__ated
created104323453cr_eated
cremated133412963cremated
crenated113013913crenated
croaked143710533cro_aked
debated113916083_debated
derogated1238673derogated
doated84118183_do_ated
donated93513863_donated
floated113312703flo_ated
fronted114011273fro_nted
frosted113211873fro_sted
frowsted1534313frowsted
gloated93511533glo_ated
globate1057823globate_
gradated1157433gradated
grated84523923gr__ated
groaned9259973gro_aned
grouted94111503gro_uted
iodated9310023_iodated
isolated9410523isolated
lobate82915243_lobate_
located103114183_located
moated94819003_mo_ated
niobate937703niobate_
niobates1037283niobates
notated82713663_notated
orated74221503__orated
orbited1037733or_bited
oribatid1145463oribatid
ozonated1864593ozonated
palmated132511003palmated
palpated13249763palpated
parbaked1735503parbaked
pated85237843p___ated
pennated11299543pennated
percolated1548233percolated
perforated1656893perforated
permeated1439363permeated
perorate10417923perorate_
perorates11417023perorates
personated13258293personated
phonate12411813phonate_
phonates13410643phonates
phorate12413363phorate_
phorates13413043phorates
picrated132110113picrated
pileated112711133pileated
pinnated11338553pinnated
pirated102515613p_irated
placated1338453placated
plated95225773p__lated
pleated103816633p_leated
plicated13310643plicated
plotted104612373plo_tted
pointed103813983p_ointed
pomaded13377863p_omaded
portaged12228463portaged
portaled11239203portaled
ported94223243p_o_rted
posited10511493p_osited
posted93722493p_o_sted
potted94624013p_o_tted
pouted94021393p_o_uted
prate75135983pr__ate_
prater84825353pr__ater
prates84633163pr__ates
prayed124815433pr__ayed
preacted132710943preacted
preaged11612333pr_eaged
prebade12310283prebade_
prebake1539093prebake_
prebakes1639013prebakes
precited133013813precited
predate10616893predate_
predates11615813predates
prefaced1638423prefaced
prefaded1537823prefaded
preheated1539813preheated
prelate9519693prelate_
prelates10418573prelates
prelocated1597183prelocated
prepared132210863prepared
prepasted14137663prepasted
prepaved16177223prepaved
presaged1238803presaged
pretaped13339133pretaped
pretasted12147963pretasted
priested1138393priested
primate111516283primate_
primates121515933primates
printed104016373pr_inted
priorate10411733priorate_
priorates11410763priorates
private121513263private_
privater13158533privater
privates131812373privates
probable1439053probable
probables1545433probables
probably1746413probably
probands13228393probands
probang12278383proba_ng
probangs13256213probangs
probating14311193probating
probation13412183probation
probative1649173probative
probatory1647113probatory
probe94320813prob__e_
prober104516073prob__er
probes104119453prob__es
probit103218353probit__
probities13312653probities
probits112712573probit_s
probity14299683probit_y
problem1335983prob_lem
proceed12310543pro_ceed
procreated1546443procreated
procured1336603procured
prodded1257733pro_dded
produced1456073produced
proette9312363proette_
proettes10312763proettes
profane122111863profane_
profaner13197943profaner
profanes132311573profanes
profiled14338523profiled
profiter132710203profiter
progged12409803pro_gged
programed1585893programed
prohibited1853473prohibited
projected21165823projected
prolapsed14133733prolapsed
prolately1445763prolately
prologed12189203prologed
promised133010873promised
promoed12310083pro_moed
promote11313143promote_
promoter12311453promoter
promotes12314123promotes
prompter1437983prompter
pronator10311783pronator
pronged113912393pro_nged
proofed13138723pro_ofed
propagated1644633propagated
propane112716153propane_
propanes122415823propanes
propined133111503propined
proponed132412033proponed
proposed132011073proposed
propped113311953pro_pped
prorogated1445723prorogated
prosateur1143583prosateur
prosected14158633prosected
prosed94921093pro__sed
prostate10314533prostate_
prostates11314423prostates
prostrated1349423prostrated
protases102115033protases
protatic12314743protatic
protea82214763pro__tea
protected14158653protected
protei82615313pro__tei
proteid103513673pro__teid
protend104012793pro__tend
protested12159113protested
protonated1348593protonated
protracted1545763protracted
proved125016033pro__ved
provided1536843provided
provoked1875053provoked
prowled13309913pro_wled
pulsated1136853pulsated
pupated12319353p_upated
rated65441383_r__ated
rebaited11410543_rebaited
rebate84424113_rebate_
rebater93517913_rebater
rebates95123183_rebates
redated93120923_redated
related83327573_related
remated103522473_remated
reprobate1347683reprobate_
reprobates1447363reprobates
roamed95215093_ro_amed
roared75015393_ro_ared
roasted83912663_roasted
roband92310723_roba_nd
robbed113415193_rob_bed
robed85323733_rob__ed
roosted83211883_roosted
rooted75424003_ro_oted
rotate63320343_rotate_
rotates72819773_rotates
rotted74524433_ro_tted
rousted84013323_rousted
routed75624333_ro_uted
solated83618023_solated
sorbate9311733sorbate_
sorbates10311103sorbates
sprouted1136393spro_uted
throated1247923thro_ated
togated94410663_togated
trabeated1246843trabeated
treated83618703tr_eated
troaked12438253tro_aked
trotted83711283tro_tted
unabated11310133unabated
unbated103317733_unbated
uprated103213323upr__ated
uprooted1186393upro_oted
urinated9311613urinated
violated1237883violated
zonated173310533_zonated

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 Limit1461622648.15617920.8
3Display Results2642640.1102400.0
 (SQL Overall)1786912648.43621182.0
 
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.