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

111 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
datelines108885(None) 
dateline9810351dateline_
datelined1194711datelined
baselines1138602baselines
ratlines83815292rat_lines
tapelines1138462tapelines
vaselines1246712vaselines
waterlines1348952waterlines
adenines9310193_adenines
airlines8312793_airlines
alexines15258503_alexines
alines65735223_a__lines
anilines8415143_anilines
atelier7311623_ateli_er
ateliers837883_ateliers
athelings1345113_athelings
bakelites1545993bakelites
balklines1536743balklines
baseline10310753baseline_
baseliner1144743baseliner
baseliners1243863baseliners
beelines103312803_beelines
bluelines1145833bluelines
cagelings1335413cagelings
capelins12311133capelin_s
carlines103521643ca_rlines
cartelises1247683cartelises
cartelizes2147633cartelizes
catlings113712043cat_lings
catlins93818843cat_lin_s
chatelaines1653383chatelaines
cutlines102413273cut_lines
dabblings15193883dabblings
daemones11209163da_emones
dailies84219263da_ili_es
dailiness1038673da_iliness
dallies84023193da_lli_es
darklings1533983darklings
darlings103710383da_rlings
dataries9314033datari_es
datedness1187753date_dness
dateless9259963datel_ess
datelining1244363datelining
datives11310073dat__ives
dauphines1544343dauphines
dayflies1534463dayfli_es
deadlines11138503deadlines
declines113315803d_eclines
defines114118683d__efines
delaines9312963d__elaines
delimes10314193d__elimes
determines1358433determines
draglines1145993draglines
drivelines1444593drivelines
duvetines1344723duvetines
eateries8324313eateri_es
ektexines2041963ektexines
fatlings12359303fat_lings
felines104718073__felines
flatlines12268433flat_lines
gantlines1039333gantlines
gasolines1047483gasolines
gatelike1337933gatelike_
hairlines1237133hairlines
hotlines11811643hot_lines
interlines101116453interlines
javelinas19353583javelinas
javelined2043323javelined
javelins18277733javelin_s
jawlines18126363ja_wlines
kaolines1239293ka_olines
landlines1039763landlines
lanolines939983lanolines
laterites9715053laterites
laterizes18513013laterizes
latrines8515003lat_rines
lifelines12147053lifelines
lobelines1138563lobelines
madeleines1343613madeleines
mainlines1138513mainlines
malines93625603ma__lines
marlines103818713ma_rlines
matelotes1146333matelotes
myelines1337123_myelines
outlines82418093out_lines
panelings12107453panelings
patines95225763pat__ines
pipelines13178353pipelines
potlines10714213pot_lines
ratines75328583rat__ines
ratline74517803rat_line_
ratlins73615583rat_lin_s
rattlings10235513rattlings
ravelings13377383ravelings
ravelins113011603ravelin_s
relines75331323__relines
salines74029413sa__lines
satellites1045423satellites
setlines8312743set_lines
sidelines10109683sidelines
stateliness1144233stateliness
taglines92210833ta_glines
tapeline10310363tapeline_
timelines1148443timelines
valines104520213va__lines
vaseline1138613vaseline_
vitellines1394733vitellines
wateriness1348073wateriness
waterings13229253waterings
waterline1249653waterline_
zibelines2045733zibelines

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.423422437.4
2DLD Change Limit1486411116.71622132.4
3Display Results1111110.0462413.0
 (SQL Overall)1786911117.18524870.0
 
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.