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

96 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
wetwares144595(None) 
wetware1335791wetware_
bewares12313372be_wares
redwares1239052redwares
seawares1139332seawares
teawares1148082teawares
welfares1445542welfares
westwards1643392westwards
barwares13610093barwares
bedwards1596393bedwards
bedwarfs17113583bedwarfs
beswarms1544323beswarms
betakes134212523bet_akes
beware11313713be_ware_
bewared13310113be_wared
centares102913893centares
centiares1167653centiares
cetanes9315133cet_anes
decares102818533de_cares
deciares11510633deciares
declares11611313declares
dekares122710873de_kares
delftwares1751333delftwares
dewars105117073de_war_s
dewaxes18297843de_waxes
etapes85415293_et_apes
ethanes103713513_ethanes
etwees9348793_etw_ees
fetiales11319613fetiales
flatwares1544773flatwares
freewares1545943freewares
giftwares1642213giftwares
hectares1338853hectares
hektares1535813hektares
jetways2094053jetwa_ys
leewards1244983leewards
leftwards1652453leftwards
metages102714973met_ages
metalwares1543653metalwares
metates92720013met_ates
methanes133812163methanes
metres85121563met__res
networks1546143networks
outdares92712463outdares
outwards1299123outwards
outwars10912793outwar_s
ovenwares1543973ovenwares
petards104311153pet_ards
petrales10312983petrales
reawakes15348073reawakes
redware1139363redware_
retakes113718863ret_akes
retapes93917423ret_apes
retards85015003ret_ards
retaxes143615093ret_axes
retears72814923retear_s
retires74726213ret_ires
retraces101417273retraces
rewakes144614983re_wakes
rewards114813993re_wards
rewarms12439603re_warms
rewaxes173911333re_waxes
rewires104717113re_wires
seawards1237203seawards
seaware1049633seaware_
sewages1139753se_wages
sewars94018633se_war_s
softwares1564113softwares
stares66038753_st_ares
stemwares1444523stemwares
stewards1236383stewards
tares57456563__t_ares
teaware1048143teaware_
tinwares1137913tinwares
twaes86513663__twa_es
unawares1137053unawares
wares88250583___wares
warfares1436683warfares
watapes12228383wat_apes
wattages12106783wattages
wattapes1395253wattapes
wearer94319403we__arer
wearers104615903we__arers
wearies103020223we__aries
wears86030303we__ar_s
weaves123616373we__aves
webpages1643053webpages
webworks2044663webworks
webworms1843763webworms
weewees1336563weew_ees
welfare1335713welfare_
westward1543823westwar_d
wetbacks1974983wetbacks
wethers135214693wether_s
wetlands1244763wetlands
wetters103817753wetter_s

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 Filter1786911461620.420425454.8
2DLD Change Limit146162966.81321453.4
3Display Results96960.0462087.0
 (SQL Overall)178691967.27924548.8
 
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.