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

144 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
tweezers2025438(None) 
tweeners11306241tweeners
tweeters11287141tweeters
tweezer19305761tweezer_
tweezes19345701tweeze_s
beezers18349242_beezers
freezers20307172freezers
geezers17286512_geezers
sneezers17246142sneezers
sweepers13348162sweepers
teemers95012902t_eemers
teeners74415452t_eeners
teeters74018302t_eeters
tweener10306832tweener_
tweeness11246402tweeness
tweeter10288532tweeter_
tweeze18265472tweeze__
tweezed20274992tweeze_d
weeders113412932_weeders
weepers123511972_weepers
weevers13379992_weevers
wheezers23265272wheezers
beepers113612383_beepers
beezer174010523_beezer_
bleeders11448453bleeders
bleepers12377493bleepers
breeders11368893breeders
breezes18318693breeze_s
cheepers15329013cheepers
cheerers13319543cheerers
creepers12318633creepers
dwellers12356083dwellers
feeders113712863_feeders
feelers103814743_feelers
feezes184412613_feeze_s
fleecers13325933fleecers
freezer19348523freezer_
freezes193310353freeze_s
geezer16278013_geezer_
greeters92610113greeters
heeders114213743_heeders
heelers103815623_heelers
heezes184211643_heeze_s
jeepers16399193_jeepers
jeerers14328923_jeerers
jewelers1834713jewelers
keeners113610783_keeners
keepers133410983_keepers
kneelers12226213kneelers
kreuzers2132063kreuzers
meeters94714543_meeters
needers84111903_needers
peelers93615593_peelers
peepers113713673_peepers
preeners102712813preeners
reefers103312593_reefers
reekers113613143_reekers
reelers73520273_reelers
seeders83017113_seeders
seekers113712333_seekers
seemers93814333_seemers
seizers164112503_seizers
sheeters113111863sheeters
skeeters12298963skeeters
sleekers12377993sleekers
sleepers103110113sleepers
sneerers8309803sneerers
sneezer16237963sneezer_
sneezes16278503sneeze_s
speeders11339313speeders
squeezers2742553squeezers
steepers103011373steepers
steerers82511353steerers
streekers13195803streekers
swearers11328583swearers
sweaters113811063sweaters
sweeneys14294023sweeneys
sweeper12329373sweeper_
sweetens11255433sweetens
sweeter103212003sweeter_
swelters113110193swelters
swervers1455213swervers
taperers10269773taperers
tearers75218233t_earers
teasers75317243t_easers
teazels16406893t_eazels
tedders94010233t_edders
teemer85515743t_eemer_
teener64717503t_eener_
teepees939263t_eepees
teeter65420313t_eeter_
teethers11328713teethers
telfers10299073t_elfers
tellers73717593t_ellers
tempers113513013t_empers
tenders83719723t_enders
tenners74014923t_enners
tenters73921103t_enters
termers95414503t_ermers
testers74124543t_esters
tethers103815313t_ethers
tetters74320473t_etters
theaters114211903theaters
treaders93311843treaders
treaters83615843treaters
treeless839283treeless
trekkers1133803trekkers
twangers12226063twangers
tweedier1253623tweedier_
tweedles1234113tweedles
tweeds10498433tw_e_eds
tweenies11146393tweenies
tweens9489843tw_e_ens
tweeted11336583tweete_d
tweets94210103tw_e_ets
tweezing21384113tweezing
twelves1334303twelve_s
twiers95410163tw__iers
twiners10459633tw_iners
twirlers11274303twirlers
twisters11268173twisters
twitters11296773twitters
twofers1364053tw_ofers
twyers12497413tw__yers
tzetzes1532673tzetze_s
weaners104613833_weaners
wearers104615903_wearers
weavers133714463_weavers
webers11310943_w_ebers
wedders123610723_wedders
weeder103315513_weeder_
weeper114313303_weeper_
weever123811443_weever_
weewees1336563_weewees
weiners103913063_weiners
welders113313413_welders
welters103516063_welters
westers105221963_westers
wethers135214693_wethers
wetters103817753_wetters
wheelers14287733wheelers
wheezer22296673wheezer_
wheezes22306803wheeze_s
wieners103212483_wieners

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.423422437.4
2DLD Change Limit1461621446.56022280.8
3Display Results1441440.0502880.0
 (SQL Overall)1786911447.03325407.5
 
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.