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 “perpetuates” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

87 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
perpetuates158430(None) 
perpetrates1566201perpetrates
perpetuate1454791perpetuate_
perpetuated1653751perpetuated
perpetrate1476652perpetrate_
perpetrated1675072perpetrated
perpetuals1453482perpetua_ls
perpetuator1552722perpetuator
perpetuators1652662perpetuators
perpetuities1653472perpetuities
penetrates1248723pe_netrates
perennates1256773per_ennates
permeates13311773perme__ates
perpetrator1553643perpetrator
perpetrators1653393perpetrators
perpetual1344483perpetua__l
perpetually1853863perpetually
perpetuating1753803perpetuating
perpetuation1655343perpetuation
perpetuations1754983perpetuations
perpetuity1753003perpetuit_y
persecutes1444353persecu_tes
cerebrates1447924cer_ebrates
crepitates1485914crepit_ates
deprecates1547294depre_cates
depreciates1664644depreciates
depredates1445514depre_dates
deregulates13135134der_egulates
effectuates1952534_effectuates
eructates1146954_eruct_ates
eventuates1394184_eventuates
expatiates1944894_expatiates
extenuates1744474_extenuates
hebetates1446444he_bet_ates
impetrates1445454_impetrates
palpitates1445304palpit_ates
parkettes15137594parket__tes
pectates122213954pe__ct_ates
penetrate1149234pe_netrate_
penetrated1347304pe_netrated
pepsinates1446374pe_psinates
perambulates1853484perambulates
perborates1459214per_borates
percentages1653424percentages
percolates14410424per_colates
perennate1147784per_ennate_
perennated1345694per_ennated
perforates1558864per_forates
perfusates1543994per_fusates
periodates1347864per_iodates
peripatuses1552904peripatu_ses
peripetias1446324peripetia__s
peripeties1448404peripet__ies
permeases1347104perme__ases
permeate12311614perme__ate_
permeated1439374perme__ated
permutes1238714per__mu_tes
perorates11417024per__orates
perpents122312044perpe__nt_s
perpetrating1745204perpetrating
perpetration1647134perpetration
perpetrations1746374perpetrations
persecute1344884persecu_te_
persecuted1543504persecu_ted
persecutee1453864persecu_tee
persecutees1552224persecutees
perseverates1753154perseverates
personates122510694per_sonates
persuades1245624per__suades
pertusses1145384per__tusses
pipettes1237564p_ipet__tes
predates11615824p_r_e_dates
prelates10418584p_r_e_lates
pretapes122811534p_r_et_apes
pretastes11119424p_r_etastes
proettes10312764p_roet__tes
propitiates1546204propitiates
prostates11314424p_rost_ates
prostrates12411994p_rostrates
punctuates1443454p_unctuates
reoperates1249664reope_rates
reregulates12135804rer_egulates
resituates1047754re_situates
terneplates1353334terneplates
vegetates1346404ve_get_ates
veritates12310974ver_it_ates
vertebrates1693564vertebrates

Search took 10 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 Filter1786911488190.453394461.4
2DLD Change Limit148819878.53317440.4
3Display Results87870.0461891.3
 (SQL Overall)178691879.03219784.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.