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

152 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
teaware104814(None) 
seaware1049631seaware
teawares1148081teawares
aware86420022__aware
beware11313712be_ware
reawake14457892reawake
redware1139362redware
seaward1148182seaward
seawares1139332seawares
stemware1344882stemware
teacake1335452teacake
teacart91113192teacart
tinware1038602tinware
unaware1038032unaware
wetware1335792wetware
awake125014783__awake
award97118043__award
barware12610703barware
bedward1497473bedward
bedwarf16106463bedwarf
beswarm1445783beswarm
bewared13310113be_wared
bewares12313373be_wares
centare93113703centare
clayware1643933clayware
creamware1642533creamware
dealate83617843dealate
decare93919153de_care
deciare10710663deciare
declare10411223declare
dekare112811563de_kare
dewar95817733de_war_
dewars105117073de_wars
eagre64315323_ea_gre
etagere836533etagere
feature1039853feature
flatware1444883flatware
freeware1446173freeware
hectare1238463hectare
hektare1435503hektare
leafage1194573leafage
leakage1235003leakage
leeward1135783leeward
meagre9349323mea_gre
measure939033measure
metalware1443603metalware
ovenware1444243ovenware
rearward1245783rearward
reawaked16366623reawaked
reawaken15345563reawaken
reawakes15348073reawakes
reawoke14397443reawoke
redwares1239053redwares
rewake135218463re_wake
reward106017643re_ward
rewarm115913493re_warm
rewire95421413re_wire
rewore938030163re_wore
scalare93311833scalare
seafarer1144843seafarer
seamark1336723seamark
seawall1046203seawall
seawan94111223seawa_n
seawans10379943seawans
seawant103613413seawant
seawards1237203seawards
seawater1136603seawater
seaway12309993seawa_y
seaways13307513seaways
sewage10310733se_wage
sewar85421103se_war_
sewars94018633se_wars
stealage946583stealage
stearate839723stearate
stemwares1444523stemwares
steward1138063ste_ward
sware85828213__sware
tabard9313333t_abard
tabaret92717313t_abaret
takahe1335793t_akahe
talar56225383t_alar_
talars66021683t_alars
tamale83717403t_amale
tamari8313403t_amari
tare45957623t___are
tarre55825633t_a_rre
tartare73012683tartare
tatar56122063t_atar_
tatars64619793t_atars
tawdry13395253t_awdry
tawer85223443t_awer_
tawers94118603t_awers
tawie84819813t_aw_ie
tawpie11339143t_awpie
tawse85616503t_aw_se
teaboard1146293teaboard
teacakes1435883teacakes
teacarts10116073teacarts
teacher123714833teacher
tealike111111083tealike
teamaker1445113teamaker
teammate1245613teammate
teamwork1744563teamwork
tear45242883te__ar_
tearable101512673tearable
teared75722153te__ared
tearer64822903te__arer
tearers75218233tearers
tearier73815613tearier
tears55436463te__ars
teary85124053te__ary
teasable101511173teasable
tease55428713te__ase
teaser65421523teaser_
teasers75317243teasers
teatime9310083teatime
teazle15329553tea_zle
teenage8108053teenage
telae54323293te_la_e
tenace82715693te_nace
teniae64517353tenia_e
tentage81010643tentage
tenure6311613te_nure
terawatt1147373terawatt
ternary1038343ternary
ternate7415483ternate
terrace93311843terrace
terrae62915213terra_e
terrane72814233terrane
testae64216253testa_e
testate73916233testate
texture1497083texture
thanage11117943thanage
thawer12489343thawer_
thawers13428483thawers
theatre10358493thea_tre
thrawart1445163thrawart
thwart12311683t_hwart
tinwares1137913tinwares
towage1039833t_owage
toward10311063t_oward
trawler104011903trawler
treasure846753treasure
treenware1243773treenware
tuatara745513tuatara
twae74719573t__wa_e
unawake1445343unawake
unawares1137053unawares
vaward13498723_vaward
ware76254723___ware
welfare1335713welfare
wetwares1445953wetwares

Search took 7 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.390458182.1
2DLD Change Limit1340271526.04622167.9
3Display Results1521520.0632412.7
 (SQL Overall)1786911526.49927495.2
 
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.