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

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

62 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
sweaters11381106(None) 
seaters74028941s_eaters
swearers11328581swearers
sweater103712721sweater_
swelters113110191swelters
beaters94925042_beaters
bleaters103412322bleaters
cheaters133613512cheaters
dewaters122910722dewaters
eaters65535952__eaters
heaters104225222_heaters
pleaters103613792pleaters
scepters1237792scepters
sealers74323552s_ealers
seamers94719432s_eamers
seater64534162s_eater_
setters73822062s_etters
shearers113911322shearers
sheathers1557552sheathers
sheeters113111862sheeters
shelters113412812shelters
skaters113512962s_katers
skeeters12298962skeeters
skelters12349372skelters
slaters73123732s_laters
smearers10308622smearers
smelters103310512smelters
sneakers12308642sneakers
speakers14299452speakers
spearers103711142spearers
specters122811062specters
spelters103912242spelters
staters73922342s_taters
stealers83412202stealers
steamers103410872steamers
swagers114211022sw_agers
swathers144512082sw_athers
swatters113911792swatters
swayers13398852sw_ayers
swearer10349952swearer_
swears94114072swea__rs
sweated113411542sweate_d
sweatier1147032sweatier_
sweats94814612sweat__s
sweepers13348162sweepers
sweetens11255432sweetens
sweeter103212002sweeter_
swelter103711172swelter_
swervers1455212swervers
swifters14277482swifters
swotters11448482swotters
theaters114211902theaters
treaters83615842treaters
tweeters11287142tweeters
waters95030632_w_aters
weaners104613832_weaners
wearers104615902_wearers
weathers143412832_weathers
weavers133714462_weavers
welters103516062_welters
westers105221962_westers
wetters103817752_wetters

Search took 5 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 Filter1786911210590.390458182.1
2DLD Change Limit121059624.01630144.2
3Display Results62620.0302066.7
 (SQL Overall)178691624.43640282.0
 
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.