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

107 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
perorations1331406(None) 
perforations1747871perforations
peroration12316001peroration_
prorations12314461p_rorations
decorations14312882decorations
derogations1349392derogations
percolations1648052percolations
perforation1649002perforation_
permeations1549882permeations
perorating13313132perorati_ng
perorational1446392perorational
perorators1249352perorat_ors
personations1448392personations
probations14311082p_robations
pronations12314032p_ronations
proration11415982p_roration_
serrations10313092ser_rations
aberrations1346693aber_rations
abrogations14116463abrogations
adorations11310233_adorations
aerations9317903ae__rations
approbations1854243approbations
arrogations12126483arrogations
cerebrations1646963cerebrations
colorations13911893colorations
coronations13410703coronations
corotations1349763corotations
corporations16129483corporations
deaerations12311673deaerations
decoration13314423decoration_
deflorations1646063deflorations
deformations1846843deformations
denotations1239853denotations
deportations1548463deportations
derivations15611493derivations
derogation12410393derogation_
desolations12310593desolations
desorptions1445993desorptions
detonations1239373detonations
evocations15259873_evocations
federations1548883federations
generations12311423generations
herniations1447403herniations
meliorations1466753meliorations
mercurations1646563mercurations
narrations1038943nar_rations
nervations1359483ner_vations
operations12312953ope__rations
orations81515803___orations
peculations15310283peculations
pejoratives2353503pejoratives
peltations12311553pe_ltations
penetrations1448853penetrations
perceptions1798193perceptions
percolation1549223percolation_
perditions1348873per_ditions
perennations1447253perennations
perfections1848143perfections
perforating1747023perforati_ng
perforators1644853perforat_ors
permeation14410563permeation_
permutations1646503permutations
perorates11417023perorat__es
perorator1149743perorat_o_r
perpetrations1746373perpetrations
personation1349483personation_
perspirations1786173perspirations
persuasions1383913persuasions
perturbations17123263perturbations
pervasions1545663per_vasions
phonations1538313p_honations
portions10514413p__or_tions
potations111615073p__otations
predations13812153p_redations
preformations2045713preformations
preoptions1447643preo_ptions
preparations1648313preparations
preportions1548263prepor_tions
privations15310103p_rivations
proactions1449343p_roactions
probation13412183p_robation_
procreations1647273p_rocreations
procurations1647403p_rocurations
promotions1448783p_romotions
pronation11415703p_ronation_
prorating12314283p_rorati_ng
prorogations1556723prorogations
prostrations1449763p_rostrations
protractions1646643p_rotractions
purgations1346743pur_gations
recordations1548643recordations
reformations1747603reformations
relocations13311143relocations
renovations1448423renovations
reparations13611663reparations
reprobations1647773reprobations
resorptions1347233resorptions
restorations12410953restorations
retortions1049143retor_tions
revocations16410313revocations
rogations101510823__rogations
rotations91613843__rotations
separations1369273separations
seriations10316683ser_iations
serration9414063ser_ration_
venerations14411313venerations
vernations13310333ver_nations

Search took 6 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 Filter1786911216330.373479064.3
2DLD Change Limit1216331075.12623728.6
3Display Results1071070.0631698.4
 (SQL Overall)1786911075.56232127.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.