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

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

54 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
lacklusters175173(None) 
lackluster1652021lackluster_
blacklisters2051742blacklisters
backlashers22123633backlashers
balusters1136643ba__lusters
blacklister1952263blacklister_
blockbusters2251613blockbusters
clusters102912403__c_lusters
accouters1344864_accou_ters
accusers12285904_ac_cus_ers
adjusters1744164_a_djusters
backbiters2095584back_biters
backlasher21124484backlasher_
backlashes21125304backlashe_s
backlisted1944504backliste_d
backlists17117414backlist__s
backrushes2143774backrushe_s
backwaters2195164back_waters
ballasters1245094ba_llasters
baluster1037054ba__luster_
blacklisted2052514blackliste_d
blacklists1844184blacklist__s
blackwaters22103144black_waters
blockbuster2151694blockbuster_
blusters104413894___blusters
cacklers163710704cackl___ers
cluster94013334__c_luster_
clustery13317114__c_lustery
clutters103210354__c_lutters
clysters13227844__c_lysters
delusters1035984__delusters
dockmasters2053104dockmasters
flusters113811504___flusters
gangbusters1561784gangbusters
hacklers173710304hackl___ers
hucksters1843654huck__sters
klisters123910484___klisters
lackers134120544lack____ers
lacquerers2142704lac_querers
lacquers19125034lac_qu__ers
lamisters1157124la__misters
lamsters1099754la___msters
landlubbers1651084landlubbers
langoustes1143484langouste_s
lasters75627694la____sters
locksteps1743344lock__steps
lusters73921444____lusters
maltsters1135194ma__ltsters
saluters8319864sa__lu_ters
slicksters1643384slick__sters
subclusters1552654subclusters
tacklers143010774tackl___ers
taskmasters1752634taskmasters
unclutters1242004unc_lutters

Search took 10 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 Filter1786911488190.576310227.4
2DLD Change Limit148819548.54617413.9
3Display Results54540.0331636.4
 (SQL Overall)178691549.15519518.4
 
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.