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

118 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
blighters155574(None) 
blighter1466851blighter_
lighters123111391_lighters
plighters1545531plighters
slighters1346711slighters
blighted1546862blighte_d
blighties1546222blighties
blights133110212blight__s
blisters104015082bli_sters
blithers134711232blith_ers
brightens1565372brightens
brighter1476662brighter_
delighters1544362delighters
fighters15269402_fighters
flichters1774172flichters
lightens122510002_lightens
lighter113113442_lighter_
plighter1476622plighter_
righters122610712_righters
sighters122510602_sighters
slighter1257822slighter_
weighters1644672weighters
alighted1347673alighte_d
alights113211433alight__s
aligners9117573alig_ners
baiters94619303bai__ters
bighted142810923b_ighte_d
bights124417963b_ight__s
billeters1136873billeters
bisters93922613b_i_sters
biters83925243b_i__ters
bitters94920363b_i_tters
blasters104116143bl_asters
blathers134713793blath_ers
blatters104414093bl_atters
bleaters103412323bl_eaters
blethers13429613bleth_ers
blight124114623blight___
blighting1635733blighting
blighty16356843blight__y
blinders113911143bli_nders
blinkers14388503bli_nkers
blister94415313bli_ster_
blistery13418713bli_stery
blites84721213bli__te_s
blither124812173blith_er_
blitzers19417153bli_tzers
bloaters103311023bl_oaters
bloggers12397403blog_gers
blotters104110983bl_otters
bluchers15359033bluch_ers
blurters10348373bl_urters
blushers133911293blush_ers
blusters104413893bl_usters
brighten1466243brighte_n
brighteners1752863brighteners
brightest1545663brightest
brightness1644573brightness
brights133710233bright__s
budgeters1343593budgeters
bullfighters216993bullfighters
burghers1435633burgh_ers
daughters1443993daughters
delighter1445583delighter_
enlightens1443743enlightens
fighter143010773_fighter_
flichter1664963flichter_
flighted1646973flighte_d
flightier1644423flightier_
flightless1773393flightless
flights143310983flight__s
flirters11337933fli_rters
flitters114312173fli_tters
freighters1764123freighters
frightens1655393frightens
glisters93912603gli_sters
glitters93710543gli_tters
heightens1644713heightens
infighters1743323infighters
klisters123910483kli_sters
laughters1344593laughters
lifters104313783_li_fters
ligates82318383_ligate_s
ligers75022043_lig__ers
lighted122913503_lighte_d
lighten112811523_lighte_n
lighteners1444983_lighteners
lightered1446283_lightered
lightest121410353_lightest
lightless1386073_lightless
lightness13107433_lightness
lights104519913_light__s
limiters10249333_limiters
linters73822633_li_nters
listers74026533_li_sters
liters65429883_li__ters
litters73422573_li_tters
obligates12207853obligate_s
obligators13195443obligators
obligers1134723oblig__ers
oligomers1243533oligomers
plighted1546463plighte_d
plights13299313plight__s
righter113212383_righter_
sighers113712183_sigh_ers
sighter113412113_sighter_
slaughters1443533slaughters
sleighers1343703sleigh_ers
slighted1357393slighte_d
slightest13136943slightest
slightness1454803slightness
slights112810723slight__s
slithers114212953slith_ers
slitters84014133sli_tters
tightens12297953_tightens
tighter112910693_tighter_
weighers15135673weigh_ers
weighter1535603weighter_

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.450397091.1
2DLD Change Limit1486411186.50022867.8
3Display Results1181180.0502360.0
 (SQL Overall)1786911187.00025527.3
 
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.