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

175 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
perorate1041792(None) 
perborate13510141perborate
perforate1459461perforate
perorated12412471perorated
perorates11417021perorates
prorate9418731p_rorate
decorate11315192decorate
derogate10311352derogate
ephorate1359502ephorate
ferrate103014042fer_rate
perborates1459212perborates
percolate13411162percolate
perforated1656892perforated
perforates1558862perforates
periodate1248342periodate
permeate12311612permeate
peroral9314792perora_l
perorator1149742perorator
personate112111422personate
phorate12413362p_horate
priorate10411732priorate
probate11414482p_robate
prolate9419792p_rolate
pronate9418872p_ronate
prorated11513712p_rorated
prorates10418072p_rorates
serrate73017542ser_rate
sororate8411172sororate
abrogate11129613abrogate
aerate64830553ae__rate
aerobat9514473aerobat_
aerobats1049853aerobats
aerobrake1543583aerobrake
aerolite8315053aerolite
aerosat7417183aerosat_
aerosats8411023aerosats
approbate1546563approbate
areolate81014463areolate
arrogate91210323arrogate
aurorae739663aurora_e
berate84729023be__rate
biforate1346903biforate
borate85026153__borate
bromate11313553_bromate
cerate84829463ce__rate
cerebrate1348653cerebrate
chlorate133112693chlorate
chromate15312783chromate
cirrate92413493cir_rate
coronate103018213coronate
corotate102813933corotate
corporate13410903corporate
deaerate9314173deaerate
decorated13312213decorated
decorates12314743decorates
depurate1139983depurate
derate74531233de__rate
derivate12311203derivate
derogated1238683derogated
derogates11310973derogates
desolate9411993desolate
detonate9311193detonate
emirate91015833_emirate
ephorates1459163ephorates
ergate7315143_er_gate
errata639013_er_rata
federate12310883federate
fermate122813003fer_mate
ferrates113013423fer_rates
ferrite103312753fer_rite
generate9312903generate
herniate1148113herniate
imperforate1853053imperforate
levirate1147623levirate
meliorate1179493meliorate
mercurate1347343mercurate
narrate7313493nar_rate
neonate7311333ne_onate
nervate1039533ner_vate
operate9615733ope__rate
orate55133303___orate
overrate11615693over_rate
pastorate11411183pastorate
pectate112214693pe_ctate
peculate122414673peculate
pedate93117763pe__date
peerage1089803pe_erage
pejorative2245693pejorative
peltate92013773pe_ltate
penetrate1149233penetrate
pennate93314033pe_nnate
peonage1048723pe_onage
percale11314093per_cale
perchlorate1853753perchlorate
percolated1548263percolated
percolates14410423percolates
perennate1147783perennate
perfoliate1555443perfoliate
perforator1545443perforator
perforce1544963perfor_ce
perfusate1444833perfusate
periodates1347863periodates
perlite9317323per_lite
permease1246503permease
permeated1439373permeated
permeates13311773permeates
permute1138793per_mute
perorally1448223perorally
perorating13313133perorating
peroration12316003peroration
perorators1249353perorators
peroxide1848193peroxide
perpetrate1476653perpetrate
personae102410553persona_e
personage12226713personage
personated13258293personated
personates122510693personates
persuade1145853persuade
pervade1337023per_vade
petiolate1149153petiolate
petrale9312623pe_trale
peyote1139853peyo__te
phenolate1447493phenolate
phonate12411813p_honate
phorates13413043p_horates
picrate112014143p_icrate
pirate82322883p__irate
prate75135983p___rate
predate10616893p_redate
prelate9519693p_relate
prelocate13109523prelocate
preoral9312673preora_l
prerace11414123p_rerace
primate111516283p_rimate
priorates11410763priorates
private121513263p_rivate
probated13410863p_robated
probates12414283p_robates
procreate1348143p_rocreate
proette9312363p_roette
profane122111863p_rofane
prograde1247183p_rograde
promote11313143p_romote
pronated11414053p_ronated
pronates10418373p_ronates
propane112716153p_ropane
prorogate1247693prorogate
prostate10314533p_rostate
prostrate11412483p_rostrate
protrade1148213p_rotrade
pyruvate1643073pyruvate
recrate92621663re_crate
rectorate11411373rectorate
reformate1446953reformate
regrate82618663re_grate
relocate10713533relocate
renovate1138553renovate
reprobate1347683reprobate
reroute7313963rero_ute
resonate8513513resonate
rotate63320343__rotate
separate10310783separate
serenate81914883serenate
seriate73722473ser_iate
serosae7310253serosa_e
serrated92513433ser_rated
serrates82617023ser_rates
sororates9410473sororates
tartrate899693tartrate
tenorite8311993tenorite
ternate7415483ter_nate
terrace93311843ter_race
terrae62915213ter_ra_e
terrane72814233ter_rane
venerate11312903venerate

Search took 8 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.436409841.7
2DLD Change Limit1461621757.18620339.8
3Display Results1751750.0802187.5
 (SQL Overall)1786911757.70223200.6
 
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.