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

160 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
perorates1141702(None) 
perborates1459211perborates
perforates1558861perforates
perorate10417921perorate_
perorated12412461perorated
prorates10418071p_rorates
decorates12314742decorates
derogates11310972derogates
ephorates1459162ephorates
ferrates113013422fer_rates
perborate13510142perborate_
percolates14410422percolates
perforate1459462perforate_
perforated1656892perforated
periodates1347862periodates
permeates13311772permeates
perorator1149742perorator
perorators1249352perorators
personates122510692personates
phorates13413042p_horates
priorates11410762priorates
probates12414282p_robates
pronates10418372p_ronates
prorate9418732p_rorate_
prorated11513712p_rorated
serrates82617022ser_rates
sororates9410472sororates
abrogates12108973abrogates
aerates74627493ae__rates
aerobats1049843aerobat_s
aerobrakes1643363aerobrakes
aerolites9312583aerolites
aerosats8411013aerosat_s
approbates1645853approbates
arrogates10129423arrogates
berates94126873be__rates
borates94823013__borates
bromates12413143_bromates
cerates95428253ce__rates
cerebrates1447913cerebrates
chlorates142512273chlorates
chromates16313113chromates
coronates1110816923coronates
corotates112714283corotates
corporates14410733corporates
deaerates10313643deaerates
decorate11315193decorate_
decorated13312203decorated
depurates1239823depurates
derates84028893de__rates
derivates13310093derivates
derogate10311353derogate_
derogated1238673derogated
desolates10311793desolates
detonates10310433detonates
emirates101214853_emirates
ephorate1359503ephorate_
ergates8314493_er_gates
erratas736863_er_ratas
federates13310153federates
ferrate103014043fer_rate_
ferrites112312833fer_rites
generates10312713generates
herniates1247333herniates
levirates1247493levirates
meliorates1288903meliorates
mercurates1446853mercurates
narrates8312763nar_rates
neonates8310063ne_onates
operates10515413ope__rates
orates64328613___orates
overrates12414623over_rates
pastorates12410143pastorates
pectates122213953pe_ctates
peculates132112543peculates
peerages1189893pe_erages
pejoratives2353503pejoratives
peloruses1145873peloruses
penates93321603pe__nates
penetrates1248723penetrates
peonages1138473pe_onages
percales12313803per_cales
perchlorates1953383perchlorates
percolate13411163percolate_
percolated1548253percolated
perennates1256763perennates
perforator1545443perforator
perforators1644853perforators
perfusates1543993perfusates
periodate1248343periodate_
peripatus1344933peripatus
perlites10316363per_lites
permeases1347103permeases
permeate12311613permeate_
permeated1439373permeated
permutes1238713per_mutes
peroral9314793perora__l
perorally1448223perorally
perorating13313133perorating
peroration12316003peroration
perorations13314063perorations
peroxides1947493peroxides
perpetrates1566203perpetrates
perries93226603per_r_ies
personages13276533personages
personate112111423personate_
personated13258293personated
persuades1245623persuades
pervades1437353per_vades
petrales10312983pe_trales
peyotes1238483peyo__tes
phenolates1547013phenolates
phonates13410643p_honates
phorate12413363p_horate_
picrates122013213p_icrates
pirates93020333p__irates
prates84633163p___rates
predates11615813p_redates
prelates10418573p_relates
prelocates1468353prelocates
primates121515933p_rimates
priorate10411733priorate_
privates131812373p_rivates
probate11414483p_robate_
probated13410863p_robated
procreates1448153p_rocreates
proettes10312763p_roettes
profanes132311573p_rofanes
prolate9419793p_rolate_
promotes12314123p_romotes
pronate9418873p_ronate_
pronated11414053p_ronated
propanes122415823p_ropanes
prorogates1347313prorogates
prostates11314423p_rostates
prostrates12411993p_rostrates
protases102115033p_rotases
pyruvates1743133pyruvates
recrates102420373re_crates
rectorates12410363rectorates
reformates1546263reformates
regrates92618403re_grates
relocates11712933relocates
renovates1248453renovates
reprobates1447363reprobates
reroutes8312223rero_utes
resonates9412403resonates
rotates72819773__rotates
separates11310743separates
seriates82620673ser_iates
serrate73017543ser_rate_
serrated92513433ser_rated
sororate8411173sororate_
tartrates979563tartrates
tenorites9311093tenorites
terraces102712253ter_races
terranes82514433ter_ranes
terrases82111483ter_rases
venerates12312263venerates
veritates12310973veritates

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411607.06321045.0
3Display Results1601600.0762105.3
 (SQL Overall)1786911607.56223630.1
 
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.