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

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

86 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
perverting164662(None) 
everting122213132_e_verting
perfecting1847512perfecting
permeating1539922permeating
preventing161210262preventing
reverting132315132re_verting
adverting1437223_adverting
averting122512733__averting
beavering1538703beaver_ing
breveting1536263breve_ting
brevetting1644333brevetting
converting16313133converting
curveting1535353curve_ting
curvetting1643393curvetting
deserting11713143de_serting
devesting14249903de_vesting
diverting142410333_diverting
erecting112415063_er_ecting
exerting162211153_e_xerting
experting1938053_experting
exserting1736663_exserting
fermenting1646823fermenting
ferreting13127693ferre_ting
fevering152510083fe_ver_ing
harvesting1744413harvesting
inverting131013223_inverting
levering122212503le_ver_ing
obverting1536303_obverting
parenting12611583par_enting
pargeting1338283parge_ting
pargetting1444943pargetting
peering103520353pe__er_ing
pelleting1237953pelle_ting
peltering122011673pelter_ing
peppering1337083pepper_ing
perceiving1844663perceiving
perduring1336013perdur_ing
perforating1747023perforating
performing1844943performing
perjuring1944923perjur_ing
permitting1546303permitting
permuting1446553per_muting
perorating13313133perorating
perpending1646683perpending
perpetrating1745203perpetrating
persecuting1643833persecuting
perseverating1952523perseverating
persevering1743253persever_ing
persisting1346653persisting
perturbing1543563perturbing
pervading1636303perv_ading
perversion1545853perversion
perversions1645413perversions
perversity1853473perversity
perversive1844353perversive
pervert12315583pervert___
perverted1546103pervert_ed
perverter1445563pervert_er
perverters1544963perverters
perverts1337533pervert__s
pestering122315663pester_ing
petering112516813pe_ter_ing
portering122012303porter_ing
preaverring1743243preaverring
precenting151012153precenting
preferring1645623preferring
preheating16310723preheating
prelecting15310163prelecting
presenting131013023presenting
preserving1637363preserving
presetting131010833presetting
presorting1339983presorting
pretesting131810683pretesting
pretexting20206973pretexting
priesting1239483p_riesting
proverbing1843783proverbing
purporting1543793purporting
purveying1843573purve_ying
rerenting102617663rer_enting
reverbing15248593re_verbing
revering122918073re_ver_ing
reversing132611483re_versing
revesting132814123re_vesting
revetting132912633re_vetting
severing122013853se_ver_ing
subverting1666293subverting

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 Filter1786911406030.423422437.4
2DLD Change Limit140603866.54621479.2
3Display Results86860.0461869.6
 (SQL Overall)178691867.01525472.7
 
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.