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

118 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
permeates1331177(None) 
permeases1347101permeases
permeate12311611permeate_
permeated1439361permeated
permeances1645652permeances
permease1246502permease_
permeator1347402permeator
permeators1447402permeators
permutes1238712perm_utes
perorates11417022perorates
aerates74627493aer__ates
bedmates1349183bedm_ates
berates94126873ber__ates
bereaves1338273ber_eaves
cerates95428253cer__ates
cermets1139713cerme_t_s
creates95225203_cr_eates
cremates124216003crem_ates
derates84028893der__ates
derivates13310093derivates
derogates11310973derogates
emeutes938013_e_meutes
eremites10312603_eremites
ergates8314493_er_gates
fermatas13246223ferm_atas
fermate122813003ferm_ate_
fermented1546623fermented
fermenter1497543fermenter
fermenters15116533fermenters
ferments13311473ferment_s
ferrates113013423fer_rates
formates132814293form_ates
gemmates13307673ge_mmates
germinates1347763germinates
herniates1247333herniates
kermesses15284963kermesses
operates10515413oper__ates
palmettes1346883palmettes
parietes10714543parie_tes
parkettes15137593parkettes
pectates122213953pe_ctates
peculates132112543peculates
pelmets11309693pelme_t_s
penates93321593pe__nates
perborates1459213perborates
percales12313803per_cales
perceives1646313perceives
percents122713373percent_s
percepts14247643percept_s
percolates14410413percolates
perennates1256763perennates
perfectas16135073perfectas
perfected1736633perfected
perfecter1646043perfecter
perfecters1745433perfecters
perfectest1744813perfectest
perfectos16106073perfectos
perfects15107353perfect_s
perforates1558863perforates
perfusates1543993perfusates
perimeter1349553perime_ter
perimeters1448593perime_ters
periodates1347863periodates
peripatus1344933peripatus
perlites10316353per_lites
permeable1556813permeable
permeably1864883permeably
permeance1545913permeance
permeant12310913permea_nt
permeating1539923permeating
permeation14410563permeation
permeations1549883permeations
permeative1748523permeative
permits11314003perm_it_s
permitted1446643permitted
permittee1346683permittee
permittees1444243permittees
permitter1345963permitter
permitters1444623permitters
permute1138793perm_ute_
permuted1336703perm_uted
perorate10417923perorate_
perorated12412453perorated
perpents122312033perpent_s
perpetrates1566203perpetrates
perpetuates1584303perpetuates
persecutes1444353persecutes
personates122510693personates
persuades1245623persuades
pervades1437353per_vades
perverted1546093perverted
perverter1445563perverter
perverters1544963perverters
perverts1337533pervert_s
pirates93020333pir__ates
prates84633163p_r__ates
predates11615813p_redates
predeaths1544743predeaths
preheated1539813preheated
preheater1448913preheater
preheaters1557193preheaters
preheats1339413preheat_s
prelates10418573p_relates
primates121515933p_rimates
privates131812373p_rivates
probates12414283p_robates
proettes10312763p_roettes
pronates10418373p_ronates
prorates10418073p_rorates
pyruvates1743133pyruvates
recreates11313363recreates
remates93827113re_m_ates
seriates82620673ser_iates
serrates82617023ser_rates
teammates1345673teammates
terminates12410003terminates
termites10313693term_ites
veritates12310973veritates

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 Filter1786911486410.1731032896.0
2DLD Change Limit1486411188.46617557.4
3Display Results1181180.0502360.0
 (SQL Overall)1786911188.68920565.2
 
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.