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

70 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
tweens948984(None) 
teens56227481t_eens
treens65317871treens
tweeds10498431tweeds
tween84413741tween_
tweeny12477001tweeny
tweets94210101tweets
weens85224051_weens
atween9166612atween_
dweebs1233652dweebs
etwees9348792etwee_s
greens75716872greens
keens95721182_keens
peens76428192_peens
preens85020112preens
queens15338872queens
sheens95116992sheens
skeens103912912skeens
sweeny12358842sweeny
sweeps114110512sweeps
sweets94214432sweets
swevens1334612swevens
teels55726372t_eels
teems76019782t_eems
teen45938202t_een_
teensy9478272t_eensy
teeny85417882t_eeny
tees45353582t_ee_s
tens45647412t__ens
terns55226872t_erns
thegns10547432thegns
theins95015422theins
thens85921832t_hens
tokens104711562tokens
treen55622752treen_
trees55835762tree_s
triens65417542triens
tureens7289872tureens
twaes86513662twae_s
twains95811182twains
tweaks1335962tweaks
twee76827082twee__
tweed94915092twee_d
tweedy13455932tweedy
tweener10306832tweener
tweeners11306242tweeners
tweeness11246402tweeness
tweenies11146392tweenies
tweet84823982twee_t
tweeze18265472tweeze
tweezes19345702tweezes
twerps11345152twerps
twiers95410162twiers
twines94717272twines
twins85118982tw_ins
twyers12497412twyers
tyees86019452tyee_s
weans85326742_weans
weeds95222212_weeds
weeks125017862_weeks
ween75835462_ween_
weensy12416822_weensy
weeny115316162_weeny
weeps104120562_weeps
wees76249122_wee_s
weets85427722_weets
wens76337932_w_ens
wheens124610612wheens
whens114618762_whens
wrens85016242_wrens

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit82551702.12338884.1
3Display Results70700.0164375.0
 (SQL Overall)178691702.48271994.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.