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

109 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
blueline103687(None) 
blueliner1142991blueliner
bluelines1145831bluelines
baseline10310752baseline
beeline93314722b_eeline
bluefin1245122bluefin_
bluefins1345112bluefins
blueing103710202blue_ing
blueliners1242502blueliners
gluelike1335022gluelike
aguelike1344673aguelike
alexine142410543al_exine
algerine9810283algerine
alkaline12168283alkaline
alumine9412693alu_mine
aquiline1746873aquiline
baculine1238983baculine
bakelite1447253bakelite
balkline1437973balkline
baseliner1144743baseliner
baselines1138603baselines
beelike13379783b_eelike
beelined11277713b_eelined
beelines103312803b_eelines
belie75630383b__eli_e
belike124616283b__elike
belive115415303b__elive
beltline1036943beltline
berline93716853b_erline
beryline1337083beryline
beveling143011033beveling
bladelike1643833bladelike
bleeding12359053bleeding
bleeping13377933bleeping
blondine1137153blondine
bloodline1245173bloodline
blubbing12257013blubbing
bludging13297463bludging
bluebill1243593bluebill
bluebird1343463bluebird
bluefish1645143bluefish
bluegill1142953bluegill
blueings11305513blue_ings
blueish1236483blue_ish
bluely113310083bluel__y
bluenose1043973bluenose
bluepoint1344053bluepoint
blueprint1344263blueprint
bluesier1034943bluesier
bluesmen1244153bluesmen
bluestone1144863bluestone
bluetick1643333bluetick
bluffing17275493bluffing
bluing94914483blu__ing
bluming123511283blu_ming
blunging12328413blunging
blunting11319843blunting
blurbing13326503blurbing
blurring11277233blurring
blurting11258773blurting
blushing14339333blushing
boweling143410683boweling
bowline123613113b_owline
brucine1138273bru_cine
bubaline1247163bubaline
budlike14257873b_udlike
bugling113615343b_ugling
bulling104324793b_ulling
buntline10198063buntline
burling104421133b_urling
bustline10208843bustline
butling103516813b_utling
byline11311643b__yline
cauline92215603cau_line
clueing104110093clue_ing
cutline92914543_cutline
dateline9810353dateline
dueling93614543_dueling
feline94820143__feline
flatline11298923flatline
fluorine1147813fluorine
flutelike1663583flutelike
fueling113615133_fueling
glueing9338713glue_ing
glutelin944083glutelin_
glutelins1043943glutelins
grueling1078273grueling
gumline102810113_gumline
guyline11258173_guyline
leucine938073_leucine
lifeline11167663lifeline
lobeline1039963lobeline
lulling83616803_lulling
lupine84013533_lu_pine
myeline1238253_myeline
olefine1038023ol_efine
oleine6313793ol_e_ine
outline72321333_outline
pipeline12149503pipeline
plotline1037643plotline
plumlike1643793plumlike
purline93516533_purline
reline65434353__reline
sideline91011093sideline
subline9316893_subline
tapeline10310363tapeline
timeline1039243timeline
vaseline1138613vaseline
zibeline1946363zibeline

Search took 9 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.403443402.0
2DLD Change Limit1461621098.45617285.0
3Display Results1091090.0462369.6
 (SQL Overall)1786911098.90520066.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.