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

164 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
mainline103986(None) 
mainlined1254351mainlined
mainliner1144671mainliner
mainlines1138511mainlines
airline7315032_airline
aniline7418472_aniline
hairline1137872hairline
mailing102923342mai_ling
mainland1145212mainland
mainliners1244002mainliners
maline84529082ma__line
manlike133012782ma_nlike
marline93320952ma_rline
midline102315102m_idline
milline92519112m_illine
aiblins9311473_aiblins
ailing74331013_ai_ling
airlike11310333_airlike
airliner836953_airliner
airlines8312793_airlines
aline57243153_a__line
amandine1148553amandine
amidine103613853ami_dine
anilin6417793_anilin_
anilines8415143_anilines
anilins7416793_anilins
asinine7310723asin_ine
baculine1238983baculine
bailie83818363bai_li_e
bailing103723523bai_ling
balkline1437973balkline
barnlike1437183barnlike
baseline10310753baseline
basinlike1553383basinlike
canine83826703ca_n_ine
carline93923613ca_rline
cauline92215603ca_uline
crinoline1147773crinoline
dateline9810353dateline
dawnlike1634673dawnlike
eanling81416673ea_nling
emailing113010043emai_ling
failing113521333fai_ling
fainting123312163fainting
fanlike142610503fa_nlike
fanzine1937123fa_nzine
faunlike1534763faunlike
fawnlike1844143fawnlike
finlike14279063_finlike
gaining94015663gain_ing
gainlier965673gainlier
gantline9410903gantline
gasoline938523gasoline
hailing113820693hai_ling
hairlike1536673hairlike
hairlines1237133hairlines
hardline12310273hardline
hipline12311423_hipline
incline9314643__incline
intine61021983__intine
jailing153415843jai_ling
jawline17137063ja_wline
kainite1149543kain_ite
kaoline11310143ka_oline
landline9311443landline
lanoline8311953lanoline
machine14313493ma_chine
mackling172710063mackling
maculing13219583maculing
madeleine1244133madeleine
magazine2046553magazine
maile75232223mai_l__e
mailings113011923mai_lings
mailmen1137273mai_lmen
maiming122912723mai_ming
mainlander1352973mainlander
mainlands1244693mainlands
mainlining1343873mainlining
mainly11411493mainl__y
maintain1077723maintain_
maintained1343853maintained
maintainer1243513maintainer
maintains1167103maintains
maiolica1244483maiolica
malice104818483ma__lice
malines93625603ma__lines
malling103623663ma_lling
mandoline1248413mandoline
mangling122312623mangling
manikin132110243manikin_
manikins14189723manikins
manille92613273manil_le
mankind1437773ma_nkind
manlier92414023ma_nlier
manlily1238743ma_nlily
manliness111310123ma_nliness
manning103616383ma_nning
mannite9312903ma_nnite
mantling112012613mantling
manwise1239183ma_nwise
maplike15299273ma_plike
marbling13179883marbling
marine84230403ma__rine
marlin84220903ma_rlin_
marlines103818713ma_rlines
marling103322763ma_rling
marlins93420473ma_rlins
marlite92917073ma_rlite
masculine1346443masculine
masklike1335593masklike
mastlike1437863mastlike
maudlin1037163maudlin_
mauling103315683ma_uling
mazelike2336463mazelike
meinie82614523mein_i_e
miauling1137343miauling
midlife13248303m_idlife
midlines112613333m_idlines
millime112511403m_illime
milliner102811863m_illiner
millines102718063m_illines
milling103223683m_illing
mincing123314333m_incing
minding113317893m_inding
mingling122010933m_ingling
mining94225453m_in_ing
minting103020813m_inting
mislie83219153m_isli_e
mislike132914833m_islike
mislive122812693m_islive
moiling103417663moi_ling
moline84422033m__oline
moonlike1476643moonlike
myeline1238253m_yeline
nailing83419963nai_ling
online6315843__online
paining103920243pain_ing
painting113614423painting
quinine163011043quin_ine
quinoline1845123quinoline
railing83325643rai_ling
raining83922693rain_ing
ralline73518413ra_lline
ratline74517803ra_tline
sailing83927373sai_ling
saining83621393sain_ing
sainting93215733sainting
saintlike1344783saintlike
saline65132703sa__line
sanidine939853sanidine
skinlike1134873skinlike
tagline82412453ta_gline
tailing82923103tai_ling
taillike1237863taillike
tainting93613583tainting
tapeline10310363tapeline
tinlike11248803_tinlike
vailing113817953vai_ling
valine94623093va__line
vaseline1138613vaseline
veinlike1534313veinlike
waiflike1834573waiflike
wailing113620903wai_ling
waistline1244173waistline

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 Filter1786911461620.483369960.7
2DLD Change Limit1461621646.65621959.4
3Display Results1641640.0762157.9
 (SQL Overall)1786911647.21524766.6
 
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.