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

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

69 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
wiretapping195179(None) 
livetrapping2051433livetrapping
pretaping1439133_preta_ping
recapping1636453__recapping
remapping1635023__remapping
retaping113012553__reta_ping
wiretapped1851773wiretapp_ed
wiretapper1751973wiretapp_er
wiretappers1851873wiretappers
wrapping16297623w_r__apping
airdropping1751864airdropping
becapping1834244__becapping
caretaking1765334careta_king
crapping153911454_cr__apping
fireballing1742644fireballing
firefanging1951794firefanging
foretasting1554424foretasting
frapping16348104_fr__apping
inwrapping1842794_inwrapping
kidnapping2041494ki_dnapping
kneecapping225974kneecapping
misstamping1842994misstamping
misstepping1862754misstepping
misstopping1852434misstopping
overlapping1945414overlapping
overtipping1945234overtipping
overtopping1945654overtopping
petnapping1442304__petnapping
prepping12309764_pre__pping
prestamping1863654_prestamping
pretasting13239284_pretasting
pretyping1764944_pret_yping
prewrapping1842394_prewrapping
rapping123619104__r__apping
reaping103621214__re_a_ping
redipping1555594__redipping
relapsing1236844__relapsing
repping123314984__re__pping
restamping1565214__restamping
retacking1658974__retacking
retagging1236034__retagging
retailing103214734__retailing
retaining102114734__retaining
retaking133114284__reta_king
retarding111110654__retarding
retasting102513414__retasting
retaxing162311334__reta_xing
retyping14255614__ret_yping
revamping1734634__revamping
rewrapping1843344__rewrapping
riprapping1452084ri_prapping
scrapping1635744scr__apping
sidestepping1851464sidestepping
strapping1436994str__apping
tapping123317134____tapping
threaping15106114thre_a_ping
tittupping1541364ti_ttupping
trapping132911394_tr__apping
videotaping1851704videota_ping
wapping153514604w____apping
whapping19317114w___happing
wiredrawing1952004wiredrawing
wirelessing1551864wirelessing
wiretap12145724wireta_p___
wiretaps13144734wireta_p__s
worshipping2251554worshipping
wrappings17253714w_r__appings
wreaking163010214w_re_a_king
wreathing16266314w_re_athing

Search took 10 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 Filter1786911488190.1561145455.1
2DLD Change Limit148819699.55015583.1
3Display Results69690.0461500.0
 (SQL Overall)178691699.75218323.5
 
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.