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

80 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
sewerless124430(None) 
dowerless1344012dowerless
peerless1037512pe_erless
powerless1444292powerless
seedless9319512se_edless
seeress7311572se_er_ess
showerless1642542showerless
angerless1045023angerless
aweless1038723_awe_less
beefless1335493be_efless
bowelless1443833bowelless
centerless1245003centerless
cheerless1495293cheerless
coverless1436803coverless
deedless10318253de_edless
dewless1137473dew__less
earless74316073_e_arless
eyeless1058053_eye_less
fearless1137873fe_arless
feeless103511103fe_e_less
feetless1137383fe_etless
fenderless1443533fenderless
fiberless1444453fiberless
flowerless1642883flowerless
gearless937373ge_arless
heedless12278813he_edless
heelless11257653he_elless
heirless1146053he_irless
jewelers1834713jewe_lers
jewellers1943543jewellers
keelless12236193ke_elless
leaderless1143433leaderless
linerless936333linerless
needless9308333ne_edless
newsless1134533new_sless
orderless1044313orderless
paperless1345833paperless
peeress939503pe_er_ess
powderless1642593powderless
riderless1044903riderless
riverless1244943riverless
savorless1243213savorless
scarless10189053s_carless
scoreless1155603scoreless
seamless10238723se_amless
seatless83213003se_atless
selfless1135013se_lfless
senseless945973senseless
severeness1346123severeness
severest11310323sever_est
sewerages1345363sewerages
sewered112911243sewer_e_d
sewerlike1643793sewerlike
sewers94719723sewer___s
sexless1467243s__exless
sheerlegs1343293sheerlegs
sheerness1236273sheerness
sheetless1235823sheetless
shelterless1452043shelterless
shoeless1137803shoe_less
shoreless1236633shoreless
sinewless1244363sinewless
sleepless1144553sleepless
soberness1186463soberness
soleless8910033sole_less
stairless9185623stairless
starless81610843s_tarless
stemless1036653s_temless
sterlets8169273s_terlets
stewardess1442263stewardess
sugarless1043673sugarless
sweetness1245683sweetness
swellest1137663s_wellest
swervers1455213s_wervers
swerves1377533s_werve_s
tearless848713te_arless
warless104015103__warless
waterless1238013waterless
webless1237003__webless
weedless12287963we_edless

Search took 9 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 Filter1786911486410.453394461.4
2DLD Change Limit148641807.76619140.0
3Display Results80800.0461739.1
 (SQL Overall)178691808.26521620.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.