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

100 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
wattape1213538(None) 
watape11208481wa_tape
wattage1186981wattage
wattapes1395251wattapes
waftage14115322waftage
wantage11119622wantage
wastage11109252wastage
watap102111672wa_tap_
watapes12228382wa_tapes
wataps11248682wa_taps
wattages12106782wattages
wattle94314212watt_le
agape85614843_a_gape
antae56828293_anta_e
atap66722453_a_tap_
ataps76414833_a_taps
attach11118393_attach
attache12106693_attache
attack12148153_attack
attain6311753_attain
attar56516693_atta_r
attars64515313_attars
attire62412383_attire
attune637983_attune
battle85217863batt_le
battue84311003batt_ue
canape10913513ca_nape
cartage10312593cartage
catface1436763catface
catnap1098383catnap_
catnaper1294933catnaper
catnaps1197033catnaps
cattail939183cattail
cattalo938423cattalo
cattie85221023catt_ie
cattle85118903catt_le
cottae84615703cotta_e
cottage104210573cottage
cuttage10318343cuttage
etape74413703__etape
guttae73210583gutta_e
guttate8328903guttate
hastate10313913hastate
lactase937963lactase
lactate9312703lactate
latte55426303latt__e
lattice938433lattice
lyttae994713lytta_e
maltase938903maltase
matte75626843matt__e
oatcake1345363oatcake
outtake11310793outtake
partake1339643partake
pattee84323383patt_ee
pattie84020963patt_ie
pottage103310603pottage
pretape113511623pretape
rattail737803rattail
rattan63613603ratta_n
rattans73411953rattans
rattle64717613ratt_le
rattrap945263rattrap_
rattraps1044823rattraps
retape83917683_retape
sarape84817573sa_rape
satiate7315403satiate
satrap86212553satrap_
satraps95011643satraps
satrapy12497933satrapy
tape64538143___tape
tartare73012683tartare
tattie64817513tatt_ie
tattle64115653tatt_le
twattle1064273twatt_le
vantage11109893vantage
vittae93911003vitta_e
vittate10409733vittate
waftages15105393waftages
wafture1334853wafture
wagtail1145043wagtail
wakame1535433wa_kame
wannabe1234533wannabe
wantages12109023wantages
warfare1336733warfare
warpage1336403warpage
wartime1237743wartime
wastable131410453wastable
wastages12109753wastages
waste86125053wast__e
wastrie101210303wastrie
waterage1248663waterage
watt75545413watt___
watter93221983watt_er
wattest102412153wattest
wattled113610503wattled
wattles103814073wattles
watts86923093watt__s
wettable13148043wettable
wetware1335793wetware
wickape1843723wickape

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271006.73319906.0
3Display Results1001000.0333030.3
 (SQL Overall)1786911007.17224915.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.