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

101 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
whiteners153524(None) 
whitener1435731whitener_
whiteness1546481whiteness
whiners134011572whi__ners
whitened1535172whitene_d
whitens13428732whiten__s
whitters14359402whit_ters
whittlers1594332whittlers
wideners12257992w_ideners
wieners103212482w_i_eners
alieners889823ali_eners
batteners11238163batteners
chasteners1554793chasteners
chicaners1685363chicaners
chiselers1445453chiselers
chitters133711173chit_ters
fasteners12237053fasteners
fatteners12236873fatteners
hasteners12267813hasteners
hitchers16379993_hitchers
hitters104717593_hit_ters
listeners9147323listeners
liteness82213213_liteness
liveners11217933_liveners
loiterers936263loiterers
miterers10219683_miterers
moisteners1244783moisteners
quieteners1942983quieteners
ratteners9237263ratteners
ripeners1036833_ripeners
shiners104015943shi__ners
shiverers15155773shiverers
shorteners1345083shorteners
softeners1245133softeners
sweeteners1343163sweeteners
thickeners1943463thickeners
thinners11327753thi_nners
triteness9310363triteness
waiters104218623wait__ers
wakeners1535843w_akeners
wantoners12116673wantoners
warreners1236193warreners
waterers112312783w_aterers
weakeners1644163weakeners
weiners103913063wei__ners
westerners1344463westerners
whatever1742673whatever_
whatness1435093what_ness
wheelers14287733wh_eelers
wheezers23265273wh_eezers
whetters14246653whet_ters
whickers20297983whi_ckers
whiffers2064493whi_ffers
whifflers2142773whifflers
whimperers20122973whimperers
whimpers18276613whi_mpers
whiner124516633whi__ner_
whines125120103whi__ne_s
whingers15358723whi_ngers
whininess1535123whininess
whippers18329043whi_ppers
whirlers14286053whi_rlers
whiskers18306773whi_skers
whisperers18153053whisperers
whispers16266993whi_spers
whistlers1595163whistlers
whitebeard1951823whitebeard
whitebeards2051673whitebeards
whitecaps1942763whitecaps
whitehead1943113whitehead
whiteheads2042983whiteheads
whiten124111923whiten___
whitenesses1746653whitenesses
whitening1635103whitening
whitenings1742613whitenings
whiteouts1543173whiteouts
whiter124316393whit__er_
whites123919883whit__e_s
whiteys16396153whit__eys
whither163510253whit_her_
whitier133311063whit_ier_
whities133113253whit_ie_s
whitings15287063whitin_gs
whitter139110893whit_ter_
whittler1495193whittler_
whittles1496673whittle_s
whittrets1542493whittrets
whizzers2233423whi_zzers
wholeness1545373wholeness
widener11318693w_idener_
wideness12259473w_ideness
wiener94513543w_i_ener_
winners104316913w_i_nners
winterers12209723winterers
wiseness112010753w_iseness
witherers15146843w_itherers
withers134417753w_it_hers
witness103010013w_it_ness
witneys13274723w_it_neys
writers105513493writ__ers
writhers14398983writ_hers

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411016.75022020.9
3Display Results1011010.0333060.6
 (SQL Overall)1786911017.20324807.9
 
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.